I am using Excel 2007
Is there a way of seeing or getting the exact position coordinates of a object on a worksheet, maybe a macro that can return or display the coordinates into a cell or on the clip board?
The object is a option box called "OptionBox1"
What I mean by exact position is the left, right, up & down position.
This is because, depending on the options a user selects, the option box "OptionBox1" will be deleted and then, depending on other options a user selects, I have a macro that will create it again.
The thing I am having issues with is I want to be able to exactly place the new "OptionBox1".
I have right clicked on the option box and looked at its format and properties but there is no way to position that way so I am assuming it must be done from within the macro that creates it.
Thanks
Is there a way of seeing or getting the exact position coordinates of a object on a worksheet, maybe a macro that can return or display the coordinates into a cell or on the clip board?
The object is a option box called "OptionBox1"
What I mean by exact position is the left, right, up & down position.
This is because, depending on the options a user selects, the option box "OptionBox1" will be deleted and then, depending on other options a user selects, I have a macro that will create it again.
The thing I am having issues with is I want to be able to exactly place the new "OptionBox1".
I have right clicked on the option box and looked at its format and properties but there is no way to position that way so I am assuming it must be done from within the macro that creates it.
Thanks