Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I switch back to Excel sheet while a form is shown?
Hi! In my case, it first pops up a form and user can click "Auto" o "Manual". If user clicks Manual, I will let user to do some work in th excel sheet. After user finishes the work in the excel sheet, user wil click "Continue" on the form. I am not sure if I can do this. It seems to me when a form is pope out, user can not swich back to do any thing in the excel sheet. Please advise. Aijun -- Ai_Jun_Zhan ----------------------------------------------------------------------- Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php...fo&userid=2547 View this thread: http://www.excelforum.com/showthread.php?threadid=40018 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I switch back to Excel sheet while a form is shown?
By default sheets are loaded as being modal which mean that you can not
access anything but this form. Starting in xl 97 (IIRC) forms can be loaded as non-modal by specifiying the modal option something like this UserForm1.show False -- HTH... Jim Thomlinson "Ai_Jun_Zhang" wrote: Hi! In my case, it first pops up a form and user can click "Auto" or "Manual". If user clicks Manual, I will let user to do some work in the excel sheet. After user finishes the work in the excel sheet, user will click "Continue" on the form. I am not sure if I can do this. It seems to me when a form is poped out, user can not swich back to do any thing in the excel sheet. Please advise. Aijun. -- Ai_Jun_Zhang ------------------------------------------------------------------------ Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php...o&userid=25474 View this thread: http://www.excelforum.com/showthread...hreadid=400181 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I switch back to Excel sheet while a form is shown?
Jim, Thank you very much. Regards, Aijun. -- Ai_Jun_Zhang ------------------------------------------------------------------------ Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php...o&userid=25474 View this thread: http://www.excelforum.com/showthread...hreadid=400181 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Write data back from a form to sheet | Excel Discussion (Misc queries) | |||
Convert 29.08 hours (shown in decimal form) to time shown in "hh:m | Excel Worksheet Functions | |||
I want print excel sheet with nos in the back ground, as shown in. | Excel Discussion (Misc queries) | |||
How do I switch focus from a modeless user form back to the excel. | Excel Programming | |||
From form to sheet and back using proc | Excel Programming |