Thread: Compile Error?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Compile Error?

I am guilty of not reading and understanding the question well enough. For
that matter I am still not sure I fully understand it now. maybe Dave has
answered your question. However, the following information might also help.

If you have 2 forms open and you want to be able to work on both then they
should both be modeless.

If you show a modal form then all following code stops in the sub that shows
the form until you close the form and then the remaining code in the sub
executes.

Therefore if you open a modal form and in the same sub you try to show
another form after it then the second form will not show until the first one
is closed.

If you open a modeless form then the remaining code in the sub continues to
execute. If the code shows a modal form after the modeless form then both
forms will show but you are stuck on the modal form and cannot focus on the
modeless form until the modal form is closed.

--
Regards,

OssieMac