I have a userform that gathers quite a bit of info. The majority of the users will have their res set high enough to display the whole form so that I don't have to make it smaller and force them to scroll around to get to the various fields. However, some of them have really low res which makes the userform so big they can't even see the scroll bars. Is there a way to tell a userform to resize based on res? Or some other method that would serve to keep the form whole for the majority but visible for the rest?
