User Form Question
 

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

Steve

User Form Question
 

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

User Form Question
 

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?