Hi and thanks so much. I do cover that in this video: th-cam.com/video/WZXF6xFDhFE/w-d-xo.html However I may create a Basic VBA training just on this alone. Thank you for your Likes, Shares & Comments. It really helps.
Dera Mr. Randy, please help. how to secure VBA properties not just with password but with some softs. Of course i understand it could be cracked but how to secure VBA as much as possible. I guess this info will be useful for people who create their own macros and do it for sale.
Hey Randy. I know this is more advanced but is there away to use shapes with a class module and a custom event. Public withevents MyShapes as sheet1.shapes Private sub MyShapes_Click Do something End sub I don't know how to load the shapes into the class public withevents. I know how to do with active x commands. Plus how to do with userform commands. Is there away to do with shapes. I have many buttons and labels Over 100 I can get them to work. I like to use shapes if I can. Thanks.
Hi and thanks very much Dan. I have not needed to sue them with Class Modules, and also shapes do not work with userforms, only sheets. What is your overall goal with the 100 shapes? What are you trying to do or create?
@@ExcelForFreelancers I created the game minesweeper and battleship in Excel and although I have it working with active x commands. On a worksheet. I wanted to use shapes because they can be formatted a lot better than what you can do with the active x commands. I tried using a collection for the shapes and an array like I did with the active x commands but it doesn't trigger the class module custom click event.
Hi and thanks. This is a bit out of my usual comfort zone however i know an expert on this who has done amazing things, just like this. Check out www.ExcelUnusual.com His name is George Lungu and he has created many graphics and games in Excel I hope this helps and thanks so much.
😱 𝗧𝗨𝗥𝗡 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗗𝗔𝗧𝗔 𝗜𝗡𝗧𝗢 𝗦𝗜𝗠𝗣𝗟𝗘 𝗦𝗢𝗟𝗨𝗧𝗜𝗢𝗡𝗦 𝗪𝗜𝗧𝗛 𝗔𝗜 ▶ www.excelforfreelancers.com/AiDataAnalystYTPinnedComment
Thank you Randy for this great content. You are so clear in your explanations and everything is so practical that I can apply it right away.
For sure, you are very welcome and I am very happy to help and share
Great job Randy, as usual. Very useful, I’m doing my own macro using all this information but also the ideas you are introducing !
That is great to hear and thanks so much. I am glad to help and share
Great video that clearly demonstrates how to utilise one of the key tools in your toolbox.
Fantastic and thanks so much. I am happy to help and share
Thanks Randy ... Awesome training from basic to advanced and how it all fits together
Awesome Neren, thanks so much. That means a lot to me coming from you
Thank Randy, lm leaning a lot from you and the explanations are very simple.... God bless you
That is great to hear, and thanks so much for sharing. I am glad to help and share
Very helpful. Easy and detailed instructions. Thank you.
Great, thanks so much and I am really glad you enjoyed the training. Thank you for your Likes, Shares & Comments. It really helps.
Awesome training, Thank you so much for that incredible input!
Thanks so much, I am happy to help you for sure. Thank you for your Likes, Shares & Comments. It really helps.
انت الافضل.
You are the best !
👍⭐⭐⭐⭐⭐
Thank you so very much, I am really glad you enjoyed the training
Thank you for another great demonstration.
For sure, you are very welcome and thanks so much Adrian
Great content Randy Thank You So Much
Awesome thanks so much
Thank you so much Randy for this amazing video.
For sure, you are very welcome and I am happy to helps and share Syed
That was an aweson training Randy, thank you very much!👏
That's great to hear and thanks so much. I am really glad you enjoyed it
Thank you SO much for sharing this video! It's absolutely fascinating and important. Truly appreciate it!
For sure, you are very welcome and I am very happy to help and share
Great content and video. You are best of the best of the best. Thank you!!!
THanks so much Tom, I am so glad I can help and share. Thank you for your Likes, Shares & Comments. It really helps.
Thank you for awesome learning
For sure, you are very welcome and I am happy to help and share
Great way to highlight data for the user!
Thank you so very much, I really appreciate that
Brilliant demonstration Sir
Thank you so very much. I appreciate that
Supperb ❤
Thank you so very much, I really appreciate that, I am so glad you enjoyed it
Hello Randy
Hope you are doing well
Thanks so much Soheal, great to hear from you
how to in vba save a shape or a "copied as picture " range as a .jpg image to pc ?
Hi and thanks so much. I do cover that in this video: th-cam.com/video/WZXF6xFDhFE/w-d-xo.html
However I may create a Basic VBA training just on this alone. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers thank you so much ! u're the best !
Dera Mr. Randy, please help. how to secure VBA properties not just with password but with some softs. Of course i understand it could be cracked but how to secure VBA as much as possible. I guess this info will be useful for people who create their own macros and do it for sale.
Hi and thanks very much, try xlsPadlock here:
I hope this helps and thanks so much.
It's confusing that it is .forecolor but you are editing the background color...
Hi and thanks. Yes I agree, I wish the naming was better. Thank you for your Likes, Shares & Comments. It really helps.
Hey Randy.
I know this is more advanced but is there away to use shapes with a class module and a custom event.
Public withevents MyShapes as sheet1.shapes
Private sub MyShapes_Click
Do something
End sub
I don't know how to load the shapes into the class public withevents.
I know how to do with active x commands.
Plus how to do with userform commands.
Is there away to do with shapes.
I have many buttons and labels
Over 100 I can get them to work.
I like to use shapes if I can.
Thanks.
Hi and thanks very much Dan. I have not needed to sue them with Class Modules, and also shapes do not work with userforms, only sheets.
What is your overall goal with the 100 shapes? What are you trying to do or create?
@@ExcelForFreelancers
I created the game minesweeper and battleship in Excel and although I have it working with active x commands.
On a worksheet.
I wanted to use shapes because they can be formatted a lot better than what you can do with the active x commands.
I tried using a collection for the shapes and an array like I did with the active x commands but it doesn't trigger the class module custom click event.
Hi and thanks. This is a bit out of my usual comfort zone however i know an expert on this who has done amazing things, just like this. Check out www.ExcelUnusual.com
His name is George Lungu and he has created many graphics and games in Excel
I hope this helps and thanks so much.
@@ExcelForFreelancers
Thanks
😅👍
Thank you so very much, I really appreciate that
🤯🤯🤯😵💫😵💫😵💫🤦
Thank you so very much, I really appreciate that Gustavo
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack