I would like to show userform1 automatically when I access sheet4 in my
workbook...anyway to accomplish this?

Steve

Put this into the worksheet module for Sheet4
(substitute the name of the form if needed)

Private Sub Worksheet_Activate()
Userform1.Show
End Sub

--
steveB

Remove "AYN" from email to respond
"Steve Klenner" wrote in message
...
I would like to show userform1 automatically when I access sheet4 in my
workbook...anyway to accomplish this?

Steve

Put this in your sheet4 code module:

Private Sub Worksheet_Activate()
Dim fmMyForm As UserForm1
Set fmMyForm = New UserForm1
fmMyForm.Show
End Sub


In article ,
"Steve Klenner" wrote:

I would like to show userform1 automatically when I access sheet4 in my
workbook...anyway to accomplish this?