UserForm Size On Different Computers
Could you check the Username?
Environ("UserName")
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"Minitman" wrote in message
...
Greetings,
I have a workbook with a UserForm that is accessed by five different
computers. On some the UserForm fills the screen and on others it
fills about a third of the screen.
Is there anyway to get vba to check what machine is opening the
UserForm and adjust the form accordingly?
Any help is greatly appreciated.
TIA
-Minitman
|