Change caption on a macro button
 

I've placed a macro command button on a sheet and Bernie helped me make this
single button do what I thought would take 4 buttons. Now this is the only
button I need and I need to change the caption. I can't find where I change
the properties of the command button. Can someone point me in the right
direction?
Thanks,

--
Gary Beard

Hi Gary

It's the caption property:

Private Sub CommandButton1_Click()
CommandButton1.Caption = "You touched me there at " & Time
End Sub

HTH. best wishes Harald

"gbeard" skrev i melding
...
I've placed a macro command button on a sheet and Bernie helped me make
this
single button do what I thought would take 4 buttons. Now this is the
only
button I need and I need to change the caption. I can't find where I
change
the properties of the command button. Can someone point me in the right
direction?
Thanks,

--
Gary Beard

Thanks Harald,
Isn't there a way to change the properties like size, background color,
foreground color, caption etc...in a properties box?

Thanks again,
Gary Beard

Hi Gary

Yes, Rightclick it, choose Properties.
There is also a Properties button on the controls toolbox, a little hand
holding a white card.

HTH. best wishes Harald

"gbeard" skrev i melding
...
Thanks Harald,
Isn't there a way to change the properties like size, background color,
foreground color, caption etc...in a properties box?

Thanks again,
Gary Beard