how do i write a code which allows me to autorun my userform1 from Worksheet1? thanks:)
P paradise Oct 30, 2003 #1 how do i write a code which allows me to autorun my userform1 from Worksheet1? thanks
P papou Oct 30, 2003 #2 Paste this into your sheets'code (right-click on sheet tab, view code) Private Sub Worksheet_Activate() UserForm1.Show End Sub Regards Pascal
Paste this into your sheets'code (right-click on sheet tab, view code) Private Sub Worksheet_Activate() UserForm1.Show End Sub Regards Pascal
