Re: UserForm Size On Different Computers

Hey Bob,

Thanks for the reply.

I'm not sure. How would that keep the UserForm at full screen on
different computers with different resolutions? It is set for full
screen at 640 x 480 on my machine. But some of the machines will not
go down to that resolution and I'm stuck with 800 x 600 (smaller sized
UserForm). At that smaller size, I have difficulty making out what is
in the TextBoxes (I work on all of the machines from time to time).

Is there anyway to have the UserForm automatically fill the screen, no
matter what the native resolution is?

-Minitman


On Mon, 4 Dec 2006 23:25:42 -0000, "Bob Phillips" <bob.NGs@xxxxxxxx>
wrote:

Could you check the Username?

Environ("UserName")

.

Relevant Pages

  • Re: UserForm Size On Different Computers
    ... I seem to have a problem using resolution as the trigger. ... I have two machines both with 800 x 600 resolution. ... workbook and UserForm full screen and the other opens them much ...
    (microsoft.public.excel.programming)
  • Re: Userform and screen resolution
    ... Private Sub UserForm_Initialize ... if you wanted to resize everything you would have to do it ... I ended up setting my screen size to the lowest resolution I ... > that the userform is much less than full screen when run on my machine ...
    (microsoft.public.excel.programming)
  • Re: Adjust userforms to fit in screen
    ... They have a lap top and the resolution is as high as it can go, ... "Jacob Skaria" wrote: ... "Ryan H" wrote: ... Is there a way for VBA to automatically adjust the userform to ...
    (microsoft.public.excel.programming)
  • Re: Userform and screen resolution
    ... AFAIK, if you wanted to resize everything you would have to do it all ... I ended up setting my screen size to the lowest resolution I ... > I have a userform which is can be viewed perfectly on my machine ...
    (microsoft.public.excel.programming)
  • Re: Adjust userforms to fit in screen
    ... If the resolution is set properly, they should get the same view ... their screen resolution set to an unconventional setting. ... "Jacob Skaria" wrote: ... Is there a way for VBA to automatically adjust the userform ...
    (microsoft.public.excel.programming)
Loading