First, it's Chip Pearson's site.

Second, Chip's code resizes the userform--not the controls on the userform (is
that what "main window" means???). You'll have to take care of that
yourself--for each control that you want to resize.

Third, I'd weasel out and make the userform fit the worst display settings
possible. Maybe even redesign it to show less stuff (use multipages
instead????).



Brian wrote:

I have a User Form that I need to adjust to fit the users computer. So far I
not found anyway to get the User Form Window to Adjust. I can adjust the User
Form sixe, but the Main Window the Form located is in is still bigger than
the Screen.

I saw on Chip Petersons site exactly what I need. His code allows complete
control over the User Form just as if it was a regular window.

Can anyone help me with this code?
http://www.cpearson.com/Excel/formcontrol.aspx

--

Dave Peterson