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?


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

Userform and screen resolution
 

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"
wrote in message
...

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

Userform and screen resolution
 

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" wrote in message
...
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"
wrote in message
...

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

Userform and screen resolution
 

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

Userform and screen resolution
 

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