If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
A Print Button macro that is based on Checkbox macros | Mstr G | General Discussion | 1 | November 16th, 2004 11:55 PM |
use macro to change picture | dgreer | Powerpoint | 5 | June 24th, 2004 07:56 PM |