Re: UserForm Size On Different Computers

Could you check the Username?

Environ("UserName")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"Minitman" <exreply@xxxxxxxxx> wrote in message
news:6ea9n2hh3td6knbpkboenej751nu6k2s0h@xxxxxxxxxx
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


.

Relevant Pages

  • Re: Excel is forced to close when run a marco???
    ... You basically export the userform ... import the exported userform back to the workbook. ... This opens my userform OK, ... hold the shift key while you open the 2nd workbook so excel opens in safe ...
    (microsoft.public.excel.programming)
  • Re: Update Personal Workbook Macros when Workbook is opened.
    ... There would be a single delay to open the addin, but loading the data file would ... dim testwkbk as workbook ... set testwkbk = workbooks ... userform for the sales team to enter specifications of the ...
    (microsoft.public.excel.programming)
  • Re: Searching text
    ... (replace somewhere in email address with gmail if mailing direct) ... I have made a userform to search and highlight unique text which meets ...
    (microsoft.public.excel.programming)
  • Re: UserForm_Initialize is not recognized??
    ... "Dave Peterson" wrote: ... Start a new workbook. ... try deleting the old userform in the troublesome workbook project. ... It's only the old userform that cannot be recognized in the VBE. ...
    (microsoft.public.excel.programming)
  • RE: Problem with Userform the second time
    ... the userform is remembering where it left off. ... workbook but that did not work either. ... Set wbOpenFile = ActiveWorkbook ... Dim PLpath As String ...
    (microsoft.public.excel.programming)