Userform always visible
 

I have a Userform setup to open automatically when my file is opened. I'd
like to dock it in the upper right-hand corner and have it visible at all
times. Right now, the user must close the Userform to make adjustments to
the workbook, or change move from sheet to sheet. Is it possible to leave
the Userform visible without interferring with the workbook activity?

Userform always visible
 

If you are using Excel 2000 or later, you can show the form
modelessly. E.g.,

Userform1.Show vbModeless


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"StephanieH" wrote in
message
...
I have a Userform setup to open automatically when my file is
opened. I'd
like to dock it in the upper right-hand corner and have it
visible at all
times. Right now, the user must close the Userform to make
adjustments to
the workbook, or change move from sheet to sheet. Is it
possible to leave
the Userform visible without interferring with the workbook
activity?

Userform always visible
 

Hi StephanieH,

StephanieH wrote:
I have a Userform setup to open automatically when my file is opened.
I'd like to dock it in the upper right-hand corner and have it
visible at all times. Right now, the user must close the Userform to
make adjustments to the workbook, or change move from sheet to sheet.
Is it possible to leave the Userform visible without interferring
with the workbook activity?

Yes, depending on the version of Excel you're using. Try this:

frmMyUserform.Show vbModeless

This will allow VBA execution to continue (in versions Excel 2000 and
newer), and it will allow the user to continue interacting with Excel as
needed.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

Userform always visible
 

Yay. Worked perfectly. Thanks Chip.


"Chip Pearson" wrote:

If you are using Excel 2000 or later, you can show the form
modelessly. E.g.,

Userform1.Show vbModeless


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"StephanieH" wrote in
message
...
I have a Userform setup to open automatically when my file is
opened. I'd
like to dock it in the upper right-hand corner and have it
visible at all
times. Right now, the user must close the Userform to make
adjustments to
the workbook, or change move from sheet to sheet. Is it
possible to leave
the Userform visible without interferring with the workbook
activity?