VBA Open a Form upon Startup

N

nathandaviesuk

I have other users, using an excel spreadsheet that I have created, bu
when they first open this spreadsheet I want a message box / Form t
appear straight away.

I have already created the form.

Any help appreciated.

Thank
 
T

TheGuy

In VBA double click on "ThisWorkbook"
Change the dropdown box at the top from "(General)" to "Workbook"
Change the other dropdown to "Open"

Then:

Private Sub Workbook_Open()
UserForm1.Show
End Sub

Change userform1 to whatever your form is

Alternitivly, you could always use msgbox

Private Sub Workbook_Open()
MsgBox "some text here"
End Sub

hope this help
 
Top