position of shape

Hi

I am trying to get the screen position of a text box so I can draw an arrow to it

I created it using:

ActiveSheet.Shapes.AddTextbox(msoTextOrientationHorizontal, posx, posy, lenx, leny).Select

But later in the code I can;t sem to find any way of determining it position


Have tried

Activesheet.shapes("my shape"). nodes.item(2).left
Activesheet.shapes("my shape"). nodes.item(2).top
etc...

But no joy

Any ideas ?

You can use:

Activesheet.shapes("my shape").left =
Activesheet.shapes("my shape").top =

Activesheet.shapes("my shape").width =
Activesheet.shapes("my shape").height =

no his does not work

you can set the shape using

ActiveSheet.Shapes("my_shape").Left = 10#

but

xpos=ActiveSheet.Shapes("my_shape").Left

gives nothing

Sorry if my original question was unclear as to what I needed: I want to read the position - not set it.

woops - sorry yes it does work

curx=activesheet.shapes("my_shape").left

is a winner - error in my syntax when I tried it first time