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.
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".
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
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.
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?
- 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 :-)
Very nice, quick and simple idea. I will use that Procedure, thank you. Did you ever cover a way to make an "undo" function in a bigger project in your videos? I implemented this in my current project and I would be interested in your opinion but I don't want to needlessly waste your precious time :-) So if you're interested, tell me, otherwise don't worry :-)
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.
Ahh, happy to hear that you found it so useful! Thanks for watching and taking the time to comment!
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".
Thanks Walter!
Thank you so much Andrew and team owl
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
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
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.
Andrew, question... How do you set the default back to what it was? Not that I don't love your crazy colors... but.
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?
Can we create an xml file(custom schema) from excel data using VBA?. Do you plan to make any videos on this?
Thanks Wise!
Still waiting for tutorial about Tables :)
- 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 :-)
Very nice, quick and simple idea. I will use that Procedure, thank you. Did you ever cover a way to make an "undo" function in a bigger project in your videos? I implemented this in my current project and I would be interested in your opinion but I don't want to needlessly waste your precious time :-) So if you're interested, tell me, otherwise don't worry :-)
why mistyrose? Don't you know PapayaWhip?