Thread: Always open Excel file with Userform
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OJ[_2_] OJ[_2_] is offline
external usenet poster
  
Posts: 111
Default Always open Excel file with Userform
Hi,
Load the form from a Workbook_Open event. This is found in the
ThisWorkbook class module....

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

Hth,
OJ

Reply With QuoteReply With Quote