MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?



Posted by on August 26, 1999 3:26 PM

Scott, try

Private Sub Workbook_Open()
Load UserForm1
End Sub

'userform1 = name of your userform