Excel VBA Introduction Part 52.2 - Formatting Shapes 

The detaining Shape Fill was exactly what I need for my project! Thank you. Both of the Shape tutorials have been very important to me. I will send you my tuition later, but when I heard you say “ok that’s probably more than you ever wanted to know about fill colors and shapes than you ever wanted to know” I had to tell you it is just the opposite. Your tutorials are outstanding.

Always thankful to Wiseowl for great learning tutorials. Excellent work!!

Great tutorial once more! One thing to add: as far as I am aware, a cell color choosen from the "Standard Colors" will not be affected by changing the ObjectThemeColor. Setting the colors manually, in the dropdown colors overview there are on top the "Theme colors", and below that the "Standard Colors".

Very Good Example on this Field you the Master of Excel VBA lot of Thanks for your and your Time

Excellent video Andrew. Resting my eyes now after all those weird color choices. lol.

I very much apreciate your magnificent job You did on those tutorials. Thank You

Thank you so much Andrew and team owl

Thanks Wise! Still waiting for tutorial about Tables :)

Thank you for your videos. Always enjoy and learn a lot from your videos and replies. How does one use the same button or shape to invoke a macro on the first click them another macro on the second click. For example, I want use the same button to hide and unhide a column. 1st click hide, 2nd click unhide (undo), 3rd click hide, etc.? Thank you.

hello andrew, thanks for this helpfull video. i have a question out from this specific thread but i was unable to find a video devoted to that argument as well. i have a problem on changing format conditions usig the command .formatconditions. may i post this question here? or can you drive to a proper you tube section? thanks

Have you or can you make a video on VBA for importing graphs from Excel into PowerPoint and formatting them? Any maybe just functionality between the two programs in general?

Andrew, question... How do you set the default back to what it was? Not that I don't love your crazy colors... but.

Can we create an xml file(custom schema) from excel data using VBA?. Do you plan to make any videos on this?

- COOL tutorial!!! I learned a lot. And again it help me with my project really well :-) Is there a way to decrease a size by X points from all sides? My two ways of doing this are: width = width - X, height = height - X, or by ScaleHeight = 0.95, ScaleWidth = 0.95. - Just a thought about shape.SetShapesDefaultProperties - add there a textbox with a small tip how to undo this. I had to google it. My solution was to create a new shape, apply template I had before on "Default", than run the wba code once again to set this shape as "new" default. (Or one can Rclick on the shape and select Set as default I think). - Anyways thanks for the awesome tutorial :-)

why mistyrose? Don't you know PapayaWhip?