Paste this into your sheets'code (right-click on sheet tab, view code)
Private Sub Worksheet_Activate()
UserForm1.Show
End Sub
Regards
Pascal

"paradise" a écrit dans le message de
om...
how do i write a code which allows me to autorun my userform1 from
Worksheet1?
thanks:)