Format Command Button (Form based)

[suriyahi]

Hello, How do I go about formatting colors and styles of command buttons from the Form toolbar in excel? I do not see any options or any properties. Please suggest. Only thing I could format was the text on the command buttons. Thank you!

[GTO]

Hello suriyahi,

You can only change the formatting properties for command buttons and label controls - wherein said control(s) were created from the forms toolbar...

If you want a command button that you can change the backcolor and other such properties, display the visual basic toollbar, and select the controls toolbox. You can then create an ActiveX type command button. If you r-click on it, you can bring up a properties page.

Hope that helps?

Mark

[suriyahi]

Thanks Mark. I appreciate your help as always!!