excel form creation

rawtech
one way would be in the worksheet module add the code

Private Sub Worksheet_Activate()
userform1.Show
End Sub

when the sheet is activate it will open the userform

another is code in the open workbook