UserForm - ShowModal Error

[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? Thanks in advance.

Bria

 

[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

 

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