ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   UserForm Show problem (https://www.excelbanter.com/excel-programming/355194-userform-show-problem.html)

gabch[_6_]

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


--
gabch
------------------------------------------------------------------------
gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=519312


Tom Ogilvy

UserForm Show problem
 
Try

Application.Visible = False
UserForm1.show

--
Regards,
Tom Ogilvy


"gabch" wrote in
message ...

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





All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com