change button text color

M

Martin Just

Hiya. Have a workbook with a commandbutton called "split". The caption,
likewise, is "split" I need some vba code to change the caption's font
color from black to gray.

When I record a macro and change the ForeColor property of the button, it
only records "ActiveSheet.Shapes("split").Select" and nothing else.

TIA, Martin
 
G

Guest

Hi Martin

try something like this:
ActiveSheet.Shapes("split").DrawingObject.Font.ColorIndex = 15

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Color Change Syntax 2
Change Button Color 6
Change color of radio button caption if selected 5
Change Shape text / Color 3
Command Button color 5
How can I programatically change the caption on a button? 3
Need help with Lotus Notes Automation!!! 0
Change AutoShape Text Color in VBA? 3

Top