VBA Open a Form upon Startup

[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

 

[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

 

[nathandaviesuk]

This worked a treat.
Thanks for your help.

Natha