UserForm Show problem

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

Try

Application.Visible = False
UserForm1.show

--
Regards,
Tom Ogilvy


"gabch" <gabch.2494em_1141654204.9314@excelforum-nospam.com> wrote in
message news:gabch.2494em_1141654204.9314@excelforum-nospam.com...
>
> 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
>