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
|