View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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