How do you make a userform open automatically when you open excel?

  • Follow


I created a Userform in VBA, and want it to automatically appear upon opening 
the Excel file everytime. How do I do that?
-1
Reply Utf 3/10/2010 9:23:01 PM

Hi Evan
Paste this in "ThisWorkbook" module.
Private Sub Workbook_Open()
    userform1.Show
End Sub
HTH
John
"Evan" <Evan@discussions.microsoft.com> wrote in message 
news:E64B444D-2493-49CC-84AB-EFA6A586A191@microsoft.com...
>I created a Userform in VBA, and want it to automatically appear upon opening
> the Excel file everytime. How do I do that? 

0
Reply John 3/11/2010 2:24:26 AM

1 Replies
2385 Views

(page loaded in 0.001 seconds)


Reply: