Userform position

[gustaf111]

Hello,

How do I change the position on a userform used as pop-up form ? I would like to pop-up the userform just after and below F4.

Thanks Gustaf

 

[John_w]

See http://www.cpearson.com/excel/formposition.htm.

 

[gustaf111]

Thanks, but the code does not work if you rezise the excel form ... to say from 100% to 80% when the userform will not be displayed at the same position ...

 

[gustaf111]

Bump

 

[gustaf111]

Nobody know how to adjust the position of the userform if the excel sheet is zoomed in/out ?

Please help!!

 

[shg]

John provided a link. You could help yourself if you posted the code you used and explained exactly what someone would need to do to duplicate your problem.

For people willing to load a workbook from an external source, you could put yours on box.net and post a link.

 

[gustaf111]

Hello shg,

I have used the code in the lik, it works very good then the sheet is zoomed 100%. But if you zoom 85% the userform will end up in a different position than you had zoom 100% ... that is the problem ... sorry

 

[gustaf111]

I would like to display the userform in the same position relative to a cell for different zoom of the excel sheet

 

[gustaf111]

Bump