UserForm Show problem

[gabch]

Dear all,


Application.WindowState = xlMinimized
UserForm1.show

This has problem, the UserForm did not show after min Excel.
However some input are required from UserForm to next step in Excel VBA.
How to fix this problem?

Best regards

[Tom Ogilvy]

Try

Application.Visible = False
UserForm1.show

--
Regards,
Tom Ogilvy


"gabch" <[email protected]> wrote in
message news:[email protected]...
>
> Dear all,
>
>
> Application.WindowState = xlMinimized
> UserForm1.show
>
> This has problem, the UserForm did not show after min Excel.
> However some input are required from UserForm to next step in Excel
> VBA.
> How to fix this problem?
>
> Best regards
>
>
> --
> gabch
> ------------------------------------------------------------------------
> gabch's Profile:
http://www.excelforum.com/member.php...o&userid=30662
> View this thread: http://www.excelforum.com/showthread...hreadid=519312
>