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

 

[TheAceMan1]

How are ya gustaf111 . . .

If XL, use the [blue]Move Method[/blue] for forms. You can also adjust the forms width & height with it ...

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[gustaf111]

See

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

I have used the code in the link, 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% ...

Does anybody have a solution for that ?