vba start up

[dantb]

Can a vba form be made to start automaticaly, when the work book is open ?

 

[Jack in the UK]

try adding the script into Autpen see help files in VBE not bad stuff..

This will run as book is opened.

what you wanted?

 

[Legacy 98055]

Hi
If the name of your form is form1 use the following syntax

form1.show

Should look like the following:

Private Sub Workbook_Open()
form1.show
End Sub