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
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... "Bob Phillips" wrote in message ... You asked this question 2 days ago and the answer is the same. -- HTH Bob Phillips "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating a worksheet with a user form open on the screen
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 -- Regards, Tom Ogilvy "KimberlyC" wrote in message ... 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... "Bob Phillips" wrote in message ... You asked this question 2 days ago and the answer is the same. -- HTH Bob Phillips "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating a worksheet with a user form open on the screen
Thanks so much!!
"Tom Ogilvy" wrote in message ... 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 -- Regards, Tom Ogilvy "KimberlyC" wrote in message ... 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... "Bob Phillips" wrote in message ... You asked this question 2 days ago and the answer is the same. -- HTH Bob Phillips "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 |
#5
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 |