ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   userform question (https://www.excelbanter.com/excel-programming/357109-userform-question.html)

Peterke

userform question
 
Hi,

Having a smal problem.
First here's the code i use:

Private Sub Workbook_Open()
Application.WindowState = xlMinimized
UserForm1.Show
End Sub

When the workbook opens it gets minimized, so that part is ok.
The userform does not appear on the screen, i have to click below to see the
userform.
How do i make the userform appear on the screen without clicking below?

Regards,
Peter




All times are GMT +1. The time now is 12:09 AM.

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