Userform and screen resolution

Hi

I have a userform which is can be viewed perfectly on my machine however on another users machine the text etc are all huge and they cannot see the whole userform. Is there a quick way to resize the windows/text etc?

Not that I'm aware of, but I'll be watching for MVP replies in case I'm
wrong. AFAIK, if you wanted to resize everything you would have to do it all
in code, resizing and moving each item based on each target resolution.

My solution? I ended up setting my screen size to the lowest resolution I
was willing to support, built and tested my userforms at that resolution,
then switched my machine back for my own preferences- the end result being
that the userform is much less than full screen when run on my machine with
my normal settings invoked.

Best of luck,
Keith

"funkymonkUK" <funkymonkUK.1t6w2k_1123074847.2478@excelforum-nospam.com>
wrote in message
news:funkymonkUK.1t6w2k_1123074847.2478@excelforum-nospam.com...
>
> Hi
>
> I have a userform which is can be viewed perfectly on my machine
> however on another users machine the text etc are all huge and they
> cannot see the whole userform. Is there a quick way to resize the
> windows/text etc?
>
>
> --
> funkymonkUK
> ------------------------------------------------------------------------
> funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
> View this thread: http://www.excelforum.com/showthread...hreadid=392475
>

See if this works for you (courtesy of Ron de Bruin):

Private Sub UserForm_Initialize()

With Application

Me.Top = .Top

Me.Left = .Left

Me.Height = .Height

Me.Width = .Width

End With

End Sub


--
steveB

Remove "AYN" from email to respond
"KR" <nospam@nospam.com> wrote in message
news:ulahBRDmFHA.3380@TK2MSFTNGP12.phx.gbl...
> Not that I'm aware of, but I'll be watching for MVP replies in case I'm
> wrong. AFAIK, if you wanted to resize everything you would have to do it
> all
> in code, resizing and moving each item based on each target resolution.
>
> My solution? I ended up setting my screen size to the lowest resolution I
> was willing to support, built and tested my userforms at that resolution,
> then switched my machine back for my own preferences- the end result being
> that the userform is much less than full screen when run on my machine
> with
> my normal settings invoked.
>
> Best of luck,
> Keith
>
> "funkymonkUK" <funkymonkUK.1t6w2k_1123074847.2478@excelforum-nospam.com>
> wrote in message
> news:funkymonkUK.1t6w2k_1123074847.2478@excelforum-nospam.com...
>>
>> Hi
>>
>> I have a userform which is can be viewed perfectly on my machine
>> however on another users machine the text etc are all huge and they
>> cannot see the whole userform. Is there a quick way to resize the
>> windows/text etc?
>>
>>
>> --
>> funkymonkUK
>> ------------------------------------------------------------------------
>> funkymonkUK's Profile:
> http://www.excelforum.com/member.php...o&userid=18135
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=392475
>>
>
>

what is Me?

It's the thing that owns the code.

In this case, since the code is under the userform, it's the userform.



funkymonkUK wrote:
>
> what is Me?
>
> --
> funkymonkUK
> ------------------------------------------------------------------------
> funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
> View this thread: http://www.excelforum.com/showthread...hreadid=392475

--

Dave Peterson