Activating a worksheet with a user form open on the screen

  • Thread starter Thread starter KimberlyC
  • Start date Start date
K

KimberlyC

Hi
I have a userform that pops up requesting some data from the user. As it is
now... when the user form is opened on the screen..and worksheet 1 is
showing behind it... you cannot move around in the worksheet 1...unless you
close the userform.
Is there a way I can keep the userform opened.. but still let the user move
around in worksheet 1 while viewing the userform?

Thanks in advance
Kimberly
 
Thank Bob.
I meant to mention that it might be a second post...but I could not find my
first message I posted or a reply anywhere...
 
Kimberly,

If you have Excel 2000 or above you can set the form's ShowModal property to
False, making the form modeless. Otherwise you are out of luck.

--

HTH

Bob Phillips
 
Thanks so much!!
Tom Ogilvy said:
Kimberly,

If you have Excel 2000 or above you can set the form's ShowModal property to
False, making the form modeless. Otherwise you are out of luck.

--

HTH

Bob Phillips
Click to expand...
 
Kimberly,

Don't know if this helps but ... If you want the user to be able to select a
range to be used in your userform code, you can use a refedit control from
the userform controls toolbox.

Doug
 
Back
Top