Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating a worksheet with a user form open on the screen
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
See User Form On Open | Excel Discussion (Misc queries) | |||
Open a user form | Excel Discussion (Misc queries) | |||
User has a blank screen when document is open. | Excel Discussion (Misc queries) | |||
use a button to open a user form? | Excel Discussion (Misc queries) | |||
Copy one spreadsheet into another without activating second spreadsheet's user form | Excel Programming |