View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_5_] Minitman[_5_] is offline
external usenet poster
 
Posts: 27
Default UserForm Size On Different Computers

Hey Bob,

It turns out that the computer name is the best way to trigger the
size change. I only need to change one machine of my 5.

Your suggestion of using Environ("UserName") modified with
Environ("ComputerName") works very well. Thank you.

-Minitman



On Tue, 5 Dec 2006 12:00:08 -0000, "Bob Phillips"
wrote:

Sorry, I thought that you had that code, you just wanted to know some way of
testing before invoking it.