View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Change caption of a button

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

--
__________________________________
HTH

Bob

"Dylan @ UAFC" wrote in message
...
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

"Bob Phillips" wrote:

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.

--
__________________________________
HTH

Bob

"Dylan @ UAFC" wrote in message
...
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