Hi guys,
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!
ActiveSheet.Shapes("X").Select
Selection.ShapeRange.Move(x,y)
Thanks in advance,
Aldo.
Excel VBA - Moving Shape to specific position
Hot Topic
- Hide/unhide
- How to change line within one statement?
- Userform Controls
- IsError function from VBA6.3 to v6.0
- using dll file
- Supplying variables for a stored procedure through a form
- Projects, objects & modules
- worksheet_change and data validation
- sum if in list
- Capture Hyperlink values on open MS Access VBA
Excel VBA - Moving Shape to specific position
Lino17580
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.
azaclauson
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.
Aldo.
Dabi