editting pushbuttons

[Jean-Paul De Winter]

Hi,
I have this excel worksheet I use for years now...
Ith has some pushbuutons to execute some code. Now I want to change the
text on this pushbuttons, but I forgot how I can edit those buttons... I
tried the combination of CTRL or Alt- enter key but... no way.
Doesn anybody know how?
Thanks
JP

 

[Abdul]

If You are mentioning command buttons then right clicking will enable
you to edit the text

 

[semiopen]

Hi,
I have this excel worksheet I use for years now...
Ith has some pushbuutons to execute some code. Now I want to change the
text on this pushbuttons, but I forgot how I can edit those buttons... I
tried the combination of CTRL or Alt- enter key but... no way.
Doesn anybody know how?
Thanks
JP

If the buttons are embedded controls, go to View -> ToolBars -> Control
Tool Box. One of the buttons on the toolbar toggles in and out of
design mode. While in design mode right click and select Properties.
Caption in one of the properties you can change. When done - make sure
that you exit design mode.

hth

-semiopen

 

[Don Guillett]

Also, here is a macro I use to change many from a vlookup table.

Sub NameShapes()
Sheets("checks").Select
For Each c In [setup!a4:a15]
ActiveSheet.Shapes(c).TextFrame. _
Characters.Text = c.Offset(0, 1)
Next c
End Sub

 

[Jean-Paul De Winter]

Problem solved.... thanks
JP

semiopen schreef:

If the buttons are embedded controls, go to View -> ToolBars -> Control
Tool Box. One of the buttons on the toolbar toggles in and out of
design mode. While in design mode right click and select Properties.
Caption in one of the properties you can change. When done - make sure
that you exit design mode.

hth

-semiopen

 

[Don Wiss]

If You are mentioning command buttons then right clicking will enable
you to edit the text

No. A "command" button is what is found on the Control Toolbox. Right
clicking only works for a Forms toolbar button (simply called a Button).
semiopen explained on to do it for a Control Toolbox button.

Don <www.donwiss.com> (e-mail link at home page bottom).