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

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