How to define shape in excel VBA

[ThrottleWorks]

I want to define a shape in excel vba.

I have a left arrow shape, I have named it as MyShp in the namebox (not in VB).


I want to define this shape in my module, can anyone help me in this please.

 

[Luke M]

This should get you started.

[pre]

Sub AccessShape()
'Defined variable
Dim ThatShape As Shape

'Assign variable
Set ThatShape = ActiveSheet.Shapes("MyShp")

'Do awesome stuff
ThatShape.Select

End Sub

[/pre]

 

[ThrottleWorks]

Luke Sir, thanks a lot for the help.


Have a nice day.

 

[Luke M]

You too, sachinbizboy.