UserForms assistance Required

Hi,

Could someone please tell me how I get my UserForm2 to be dsiplayed everytime I select a tab? (apart from on opening workbook).

Help is apprecaited.

n.

Dave's suggestion is spot on. But, instead of entering that code into each sheets code, I'd use this code in the workbook code:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    UserForm1.Show
End Sub

This could save a bit of time, especially if you have a number of sheets.