Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Bubble sort Error (Compile Error: Type Mismtach) | Excel Programming | |||
VBAProject name compile error, not defined at compile time | Excel Programming | |||
error message: compile error, argument not optional | Excel Programming | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |