How To Master Shapes With Excel VBA - For Beginners

[@ExcelForFreelancers]

📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm

[@JanBolhuis]

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.

[@ExcelForFreelancers]

For sure, you are very welcome and I am very happy to help and share

[@sahralsahri7180]

انت الافضل. You are the best ! 👍⭐⭐⭐⭐⭐

[@ExcelForFreelancers]

Thank you so very much, I am really glad you enjoyed the training

[@simplejuan]

Very helpful. Easy and detailed instructions. Thank you.

[@ExcelForFreelancers]

Great, thanks so much and I am really glad you enjoyed the training. Thank you for your Likes, Shares & Comments. It really helps.

[@fanieroos5374]

Thank you for awesome learning

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to help and share

[@nerenlakhraj5252]

Thanks Randy ... Awesome training from basic to advanced and how it all fits together

[@ExcelForFreelancers]

Awesome Neren, thanks so much. That means a lot to me coming from you

[@RoronoaShu27]

Awesome training, Thank you so much for that incredible input!

[@ExcelForFreelancers]

Thanks so much, I am happy to help you for sure. Thank you for your Likes, Shares & Comments. It really helps.

[@adrianjackson7577]

Thank you for another great demonstration.

[@ExcelForFreelancers]

For sure, you are very welcome and thanks so much Adrian

[@BenLinfordUK]

Great video that clearly demonstrates how to utilise one of the key tools in your toolbox.

[@ExcelForFreelancers]

Fantastic and thanks so much. I am happy to help and share

[@kurewakwesuw]

Thank Randy, lm leaning a lot from you and the explanations are very simple.... God bless you

[@ExcelForFreelancers]

That is great to hear, and thanks so much for sharing. I am glad to help and share

[@betopalou7772]

Great job Randy, as usual. Very useful, I’m doing my own macro using all this information but also the ideas you are introducing !

[@ExcelForFreelancers]

That is great to hear and thanks so much. I am glad to help and share

[@henkvinck888]

Great content Randy Thank You So Much

[@ExcelForFreelancers]

Awesome thanks so much

[@SyedMuzammilMahasanShahi]

Thank you so much Randy for this amazing video.

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to helps and share Syed

[@karenjoy511]

Great way to highlight data for the user!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@tomjones1502]

Great content and video. You are best of the best of the best. Thank you!!!

[@ExcelForFreelancers]

THanks so much Tom, I am so glad I can help and share. Thank you for your Likes, Shares & Comments. It really helps.

[@sohealsingh]

Hello Randy Hope you are doing well

[@ExcelForFreelancers]

Thanks so much Soheal, great to hear from you

[@Tornadosigiloso]

That was an aweson training Randy, thank you very much!👏

[@ExcelForFreelancers]

That's great to hear and thanks so much. I am really glad you enjoyed it

[@santoshkiran5858]

Brilliant demonstration Sir

[@ExcelForFreelancers]

Thank you so very much. I appreciate that

[@jtwtube]

Thank you SO much for sharing this video! It's absolutely fascinating and important. Truly appreciate it!

[@ExcelForFreelancers]

For sure, you are very welcome and I am very happy to help and share

[@shaharyarahmed6124]

Supperb ❤

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that, I am so glad you enjoyed it

[@MrGoudfay]

how to in vba save a shape or a "copied as picture " range as a .jpg image to pc ?

[@ExcelForFreelancers]

Hi and thanks so much. I do cover that in this video: kzbin.info/www/bejne/jYu7d2mue6mbfKc However I may create a Basic VBA training just on this alone. Thank you for your Likes, Shares & Comments. It really helps.

[@MrGoudfay]

@@ExcelForFreelancers thank you so much ! u're the best !

[@nurgas27]

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.

[@ExcelForFreelancers]

Hi and thanks very much, try xlsPadlock here: I hope this helps and thanks so much.

[@danp6101]

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.

[@ExcelForFreelancers]

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?

[@danp6101]

@@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.

[@ExcelForFreelancers]

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.

[@danp6101]

@@ExcelForFreelancers Thanks

[@marceloreges421]

😅👍

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@gustavopineda7933]

🤯🤯🤯😵‍💫😵‍💫😵‍💫🤦

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Gustavo