VBA - Get Coordinates of Textbox

[ZedsDead]

Hi all,

I'm trying to find the coordinates of a textbox within vba. The textbox is within a user form and I'm sure there's a simple way to grab the coordinates but I've got no idea how to do it.

Thanks in advance for looking over this!

ZD

 

[Kyle123]

Assuming by co-ordinates, you mean the position in the Form, you want the top and left properties of the control

 

[ZedsDead]

Hi Kyle,

Thanks for your help! I'm trying to resize the Main Work Area so that it changes depending on where the last combobox is; I've got combo boxes being generated depending on how many the user wants.

Regards,

ZD



--Update--

Fixed the issue now, used your advice with the Top property and added some padding to push the Work Area below the combo box.

Thanks again for your help Kyle!!

 

[Kyle123]

Sorry, I don't know whether you're sorted now or you still need help

 

[ZedsDead]

All good now Kyle, cheers again for your help!