UserForm - ShowModal Error

B

Brian Hribek

I have a form that I want shown when editing the worksheet. I hav
ShowModal set to false. On my "main menu" you click a button and i
takes you to this UserForm that has ShowModal set to false. That par
works fine. You close the UserForm and it takes you back to the "mai
menu" When you click the button to go back to the form that ha
ShowModal set to false, it gives me the following error:

Run Time Error '401':
Can't show non-modal form when modal form is displayed.

Any help? :confused: Thanks in advance.

Bria
 
C

Celtic_Avenger

You main menu must have its show modal properties set to true.

You cannot show a non-modal form at the same time as a modal form.

You must Hide the main menu fisrt then show your non-modal form.

MainMenu.Hide
OtherForm.Show

Hope this helps.

Celtic_Avenger
 
B

Bob Phillips

Brian,

In Form #1 I assume you do something like

Userform2.Show

Do you do tghe same from Form 2?

UserForm1.Show

If so, change it so that Userform1 doesn't unload or get hidden, but just
unload or hide Form 2.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top