I have created a cutom button with the following code. How do I change
the font color/size of the caption on the button? Please help.

With .Controls.Add(Type:=msoControlButton)

..Style = msoButtonCaption
..Caption = "Enter the name"
..Width = 35

End With


--
shashi1515
------------------------------------------------------------------------
shashi1515's Profile: http://www.excelforum.com/member.php...o&userid=31109
View this thread: http://www.excelforum.com/showthread...hreadid=513224

Right click the button. Then go to:
-Properties
-Backcolor (Click the drop down and pick your color)
-Caption (Click to change the name of the button
-Font to change the font
You can even add a picture to the button by clicking "Picture" Then
selecting a .jpg. You can also add Wordwrap, Lock the Button, add Shadow, and
change the MouseIcon when the pointer rolls over it.
--
Dr. M


"shashi1515" wrote:


I have created a cutom button with the following code. How do I change
the font color/size of the caption on the button? Please help.

With .Controls.Add(Type:=msoControlButton)

.Style = msoButtonCaption
.Caption = "Enter the name"
.Width = 35

End With


--
shashi1515
------------------------------------------------------------------------
shashi1515's Profile: http://www.excelforum.com/member.php...o&userid=31109
View this thread: http://www.excelforum.com/showthread...hreadid=513224