Thursday, September 21, 2006 1:07 PM
Could anyone tell me how can I move a Text Box called "X" to a specific position?
I am trying something like this, but getting error!
Thanks in advance,
Monday, September 25, 2006 12:37 PMHello,
If you are using a userform and that textbox is inside the userform then you can use the .left and .top properties of the textbox.
Still I don't know if that works for a loose textbox in a spreadsheet.
Tuesday, September 26, 2006 10:17 AM
The only option I have found is... (.IncrementLeft, IncrementTop), but only moves it from one place to another. What I look for is the possibility to determinate the exact position I need.
Tuesday, October 30, 2007 6:25 PMtry .shapes(X).top = and .shapes(X).left =
Saturday, September 22, 2012 8:50 PMWith ActiveSheet.Shapes("ShapeName")
.Left = 3
.Top = 2