Form Button - Changing Text

D

Dan

I have placed a button on the sheet using the button on the forms toolbar.
When adding to the click property it is named button1. It does not function
the same way as a commandbutton, and I cannot find how to change the caption
with text. Can anyone help?
 
C

Chip Pearson

Right-click the button and choose Edit Text from the pop-up menu and type in
the caption of the button. If you're trying to do this with code, use
something like

Dim WS As Worksheet
Set WS = Worksheets("Sheet1")
WS.Buttons("Button 1").Caption = "Some New Text"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
Top