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.

"Freshman" wrote:

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 be in "Design Mode" which is set via icon on the Visual Basic
Toolbar. (View=Toolbars=Visual Basic)
HTH

"Freshman" wrote:

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.

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
"Freshman" wrote:

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.

Hi,

I must crazy to forget this. Thanks.

"FSt1" wrote:

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
"Freshman" wrote:

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.

Hi Toppers,

I must be crazy to forget this. Thanks.

"Toppers" wrote:

You need to be in "Design Mode" which is set via icon on the Visual Basic
Toolbar. (View=Toolbars=Visual Basic)
HTH

"Freshman" wrote:

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.

Hi Harimau,

I must be crazy yo forget this. Thanks.

"Harimau" wrote:

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.

"Freshman" wrote:

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.