ExcelBanter - autorun userform from worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - autorun userform from worksheet (https://www.excelbanter.com/excel-programming/281008-autorun-userform-worksheet.html)

paradise

autorun userform from worksheet

how do i write a code which allows me to autorun my userform1 from Worksheet1?
thanks:)

papou[_7_]

autorun userform from worksheet

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:)

All times are GMT +1. The time now is 09:05 AM.