View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy[_2_] Doug Glancy[_2_] is offline
external usenet poster
 
Posts: 11
Default Activating a worksheet with a user form open on the screen

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

"KimberlyC" wrote in message
...
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