R Roger on Excel Nov 25, 2009 #1 How do you make a userform open when you open a spreadsheet? Can anyone help? Thankyou, Roger [excel2003]
How do you make a userform open when you open a spreadsheet? Can anyone help? Thankyou, Roger [excel2003]
F FSt1 Nov 25, 2009 #2 hi sheet or file? sheet..... Private Sub Worksheet_Activate() Load userform1 userform1.Show 0 End Sub lookup modal and modaless forms in vb help. file.... Private Sub Workbook_Open() Load userform1 userform1.Show 0 End Sub also see this site.... http://www.mvps.org/dmcritchie/excel/getstarted.htm regards FSt1
hi sheet or file? sheet..... Private Sub Worksheet_Activate() Load userform1 userform1.Show 0 End Sub lookup modal and modaless forms in vb help. file.... Private Sub Workbook_Open() Load userform1 userform1.Show 0 End Sub also see this site.... http://www.mvps.org/dmcritchie/excel/getstarted.htm regards FSt1
T tpeter Nov 25, 2009 #3 You could also right click on the tab you want the userform to open on and type the NameOfYourForm.show. Put this on an on activate event.
You could also right click on the tab you want the userform to open on and type the NameOfYourForm.show. Put this on an on activate event.
