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?

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)


"Dan" wrote in message
...
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?

It was with code. My message wasn't very clear. Thanks for the help.

"Chip Pearson" wrote:

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)


"Dan" wrote in message
...
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?