name of object

  • Thread starter Thread starter Jean-Paul De Winter
  • Start date Start date
J

Jean-Paul De Winter

Hi,
I have a worksheet with 2 pushbuttons.
Now I added one.
How can I know which name excel has given to this newly added object?
Shape(3) doesn't seem to be correct.
Thanks
JP
 
(e-mail address removed) (Jean-Paul De Winter) wrote in
Hi,
I have a worksheet with 2 pushbuttons.
Now I added one.
How can I know which name excel has given to this newly added object?
Shape(3) doesn't seem to be correct.
Thanks
JP
Click to expand...

JP, did you create the pushbutton using the "Control Toolbox"-toolbar
or the "Forms"-toolbar? If using the first, you can check the name of
the control by going into design mode (ruler+pen+triangle-button on the
"Control Toolbox"-toolbar), then clicking on the properties-button and
then clicking on the pushbutton you added. It will then show you the
name of the pushbutton Excel has created for you. Usually it is
"CommandButton3" for the 3rd command button.

HTH,
CoRrRan
 
Back
Top