Show userform at spreadsheet open
 

How do you make a userform open when you open a spreadsheet?

Can anyone help?

Thankyou,

Roger [excel2003]

Show userform at spreadsheet open
 

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

"Roger on Excel" wrote:

How do you make a userform open when you open a spreadsheet?

Can anyone help?

Thankyou,

Roger [excel2003]

Show userform at spreadsheet open
 

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.

"Roger on Excel" wrote:

How do you make a userform open when you open a spreadsheet?

Can anyone help?

Thankyou,

Roger [excel2003]