Command Button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear experts,

I've a command button on a worksheet. When clicked, an user form will show
up. However, when I want to change the caption on the command button by right
clicking it, it didn't response to show a short cut menu. So, I cannot change
the caption. I checked some information on internet, they also stated the
same method by right click to get a menu then choose Properties.... Anyway, I
cannot make it. Is there something wrong with the button? How to correct it
so that I can change the caption. Please kindly advise.

Thanks in advance.
 
You need to go into Design Mode in order to do that. It's a button on the
same toolbar that you used to create the command button, it has a triangle
thingy.

Once you do that, just left click on the thing normally. Then right click to
go to properties. Alternatively, there's a properties button next to the
design mode button.
 
You need to be in "Design Mode" which is set via icon on the Visual Basic
Toolbar. (View=>Toolbars=>Visual Basic)
HTH
 
hi,
most probably, you're not in design mode.
right click any toolbar. from the pop up click control tool box. on that
toolbar, click design mode icon. looks like a protractor with ruler and
pencil. you should be able to right click the command button to get the popup
menu. to change caption click view properties. when done, click the design
mode incon agian to exit design mode.
to remove the control tool box tool bar, right click any tool bar. from the
pop up, uncheck contol tool box.

regards
FSt1
 
Hi,

I must crazy to forget this. Thanks.

FSt1 said:
hi,
most probably, you're not in design mode.
right click any toolbar. from the pop up click control tool box. on that
toolbar, click design mode icon. looks like a protractor with ruler and
pencil. you should be able to right click the command button to get the popup
menu. to change caption click view properties. when done, click the design
mode incon agian to exit design mode.
to remove the control tool box tool bar, right click any tool bar. from the
pop up, uncheck contol tool box.

regards
FSt1
Click to expand...
 
Back
Top