Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Positioning a control on worksheet via VBA

Status
Not open for further replies.

dean12

MIS
Oct 23, 2001
273
US
I've got a combo box control dropped on an Excel 2003 worksheet. I've positioned the control so that is overlays (as best as I could) cell D5.

If I resize the cells on the worksheet, the control moves along with the resize - it maintains its position relative to where I placed it. Good.......

Now if I want, at execution time, to move the position of the combo box from where it is at say D5 to say B10. Is there a way to figure out the position of cell B10 and then adjust the combo box properties (left/top) to have the combo box end up in the new position?
 
Have a look at the Top and Left properties of the Range object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top