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?
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?