ExcelBanter

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

Peterke

userform question
 
Hi,

There seems to go something wrong, i've posted a question twice allready but
it does not seem to appear, therefor here it comes again and hopefully it
gets thru.

Here's the code i use:

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

And here's the problem:
When the workbook opens it's minimized, so that's ok.
However the userform does not appear on the screen automaticly, i have to
click below to actually show it.

Now the question:
How do i make the userform appear on screen without clicking for it?

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