Can I switch back to Excel sheet while a form is shown?

[Ai_Jun_Zhang]

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.

[Jim Thomlinson]

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
>
>

[Ai_Jun_Zhang]

Jim,

Thank you very much.

Regards,

Aijun.