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

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

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