ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Starting a userform upon starting the file (https://www.excelbanter.com/excel-programming/272791-starting-userform-upon-starting-file.html)

Fritznel

Starting a userform upon starting the file
 
I need to know how to have a userform pop up as the file
is opened. Is there a way to do this?
Thanks,
Fritz

Heiko

Starting a userform upon starting the file
 
Type your Code inside the Open-Event of the Workbook:

Private Sub Workbook_Open()
<NameofTheUserForm.Show
End Sub

Heiko
:-)
"Fritznel" wrote:

I need to know how to have a userform pop up as the file
is opened. Is there a way to do this?
Thanks,
Fritz




All times are GMT +1. The time now is 09:27 PM.

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