name of object

  • Thread starter Jean-Paul De Winter
  • 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
 
C

CoRrRan

[email protected] (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
 
Top