Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bug When Try Using VBA.UserForms(FormName).Show
Hi All
I have problem when using VBA.UserForms(FormName).Show. If I try to hide the form that showed by above code, that will cause error : Run-time error 402 Must close or hide topmost modal form first. Is it bug or any other solution that can handle this problem? Thanks, Resant |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bug When Try Using VBA.UserForms(FormName).Show
I don't believe it is a bug. The point of a form being modal is that it has
the focus. Whether there is a workaround, would probably depend on the specifics. It might require a redesign of the way you are proceeding. -- Regards, Tom Ogilvy "Resant" wrote: Hi All I have problem when using VBA.UserForms(FormName).Show. If I try to hide the form that showed by above code, that will cause error : Run-time error 402 Must close or hide topmost modal form first. Is it bug or any other solution that can handle this problem? Thanks, Resant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel/VBA: cannot import, show, export userforms | Excel Programming | |||
VBA Excel: Can't show, import or export userforms (error: &H800040 | Excel Programming | |||
formName.Show is not working | Excel Programming | |||
formName.Show | Excel Programming | |||
UserForms | Excel Programming |