Show Userform when Worksheet selected

[Rocky0201]

Hi...

Is it possible to launch a userform when a Worksheet is selected? What I mean is, if I am in Sheet2, and then I click the Sheet1 tab, can a userform that I use for sheet1 automatically launch without the user having to change any cells in Sheet1?

Thanks...

 

[jreedich]

In Sheet 1 activate procedure just .show the form you want

Private Sub Worksheet_Activate()
UserForm1.Show
End Sub

 

[Rocky0201]

Thanks jreedich... Works exactly as I need.