name of object

[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

 

[CoRrRan]

(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

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