Change caption of a button

D

Dylan @ UAFC

Not trying to sound dense here,
but I have a active X command button
that hyperlinks to another
area in the workbook,
Everything works great, but I cannot
figure out how to change the caption
or the text display in the button
 
B

Bob Phillips

Go into design mode, double-click the button and it takes you into the VBIDE
with that control selected. You can change the caption in the properties
window.
 
D

Dylan @ UAFC

bob,
I have the macro enabled in the sheet,
If I right click the button there is no properties
option, there is a format picture option.
If I select the button and and choose the properties
tab on the developer, there is no section for
caption.
If I go Visual Basic page and
ad in
..caption = "tesxt I want inside button"

Nothing happens
 
B

Bob Phillips

I said double-click when in design mode and go to the VBIDE to set the
property there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top