When you execute the command to show your user form, specify vbModeless for
the optional argument for the Show method...

UserForm1.Show vbModeless

--
Rick (MVP - Excel)


"SteveDB1" wrote in message
...
morning all.
I got my user form to work.
I now have some questions regarding certain elements of it.
1- I'm unable to activate the worksheet that I'm operating on once the
user
form is active.
How do I code it in so I can click between worksheets?
I.e., if the worksheet is behind the form, I can just select the fields on
the active page. If the workbook is minimized, I must right click on the
toolbar for the file, and click restore.
I need to A- bring up the workbook if it's minimized, and B- click
between
worksheets while my form is active.

2- While I agree that I may misunderstand some aspects, I notice that once
I
select a cell, or range of cells-- using RefEdit-- and then select my next
range, the former range is no longer showing as having been selected. This
allows the user to lose track of where they selected, which can act to
confuse/obfuscate the ranges needed for my form/macro to work as desired.
Is there a way while the user form is actively going through all the
fields
to have the ranges showing as having been selected-- apart from what's in
the
RefEdit cells-- so the user does not get "lost"?

3- Once the user is done selecting all fields needed, and clicks OK how do
I
"unload" the user form? Do I just place an "Unload.Me" at the end of my
code?

4- What do I use to access the user form to begin with?
I know, this might be the stupidest question of them all, but I have to
ask
to make sure I've got it right.

Thank you each for your helps.
SteveB.