Automatically Loading...

Posted by Scott Purdie on August 26, 1999 3:09 PM

I just started VBA the other week.

I've created a VBA form that is used to automatically update specific fields in Excel. My form works. What I want to do is make the form automatically load when that workbook is started. Can someone tell me how to do this?

Thanks.

-Scott

Posted by phoenix@voyager.co.nz on August 26, 1999 3:26 PM

Scott, try

Private Sub Workbook_Open()
Load UserForm1
UserForm1.Show
End Sub

'userform1 = name of your userform