My colleague Chip Pearson has posted a UserForm positioning module here:Originally Posted by kpuls
Hi there, and welcome to VBAX!
You may want to go for a stroll through our KB.
For the position, try Fine-Tune Userform Start Position
And for resolution, try Screen Resolution Check / Change
HTH,
http://cpearson.com/excel/FormPosition.htm
This helps to position the form in a given position with respect to a worksheet cell, or other object on a sheet. It's handy if you have a small form that aids with user input, like a date picker. It accounts for how many commandbars are visible, where the sheet has been scrolled to, etc.
About the screen resolution, I appreciate Jake's code which merely suggests the user might want to adjust their resolution, rather than trash the user's settings. (What if it's a vision-impaired user who needs 400*600 on their 17" screen? You screw with that and it's even worse than if you merely annoy a normal user with it.) But the best approach is for the programmer to adjust his forms so that they will work on any resolution. If it means you need a special multipage interface for small screens, well, it's extra work. But it's always harder to program an app that's easier to use.
Reply With Quote