Where do I find this definition

[jragan]

I have VBA code that includes the statement below.  Where do I find the shape that is named in the quotes?

ActiveSheet.Shapes("ExternalPontoon").Visible = False

Thanks.

[#2 · Accepted solution]

@jragan 

On the Hometab of the ribbon, in the Editing group, select Find & Select > Selection Pane...

You should see a list of all shapes on the worksheet. Clicking on a name will select the corresponding shape.

[#3]

@Hans Vogelaar 

Fantastic!!! Thank you.  Now can you direct me to instructions as to how to create additional shapes?  I need to define additional shapes for code that I have added and do not have shapes for.

Thank you very much!

John

[#4]

@jragan 

Activate the Insert tab of the ribbon.

In the Illustrations group, click the Shapes dropdown.

Select a shape, then either click in the sheet where you want the shape, or click-and-drag.

After inserting a shape, right-click it and select Assign Macro from the context menu if you want to run a macro when the shape is left-clicked.