Once an userform run, it will appear just in the middle of the worksheet. How can I force it to appear, for example, on the right side of the window so you'd be able to see some information written in the middle of the worksheet?
Printable View
Once an userform run, it will appear just in the middle of the worksheet. How can I force it to appear, for example, on the right side of the window so you'd be able to see some information written in the middle of the worksheet?
Set the StartUpPosition Property of the form to 0-Manual, the Left Property to 0 and the Top Property to something like 250 (you will have to play with this value). This will position it on the extreme left of the screen.
Is there some way to fix the userform window so that it cannot be moved?