Hello,

How do I automatically activate a userform when a user selects a specific
worksheet tab? What's the code for that?

Thank you

Place code on the Workbook code page

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Sh.Name = "Sheet1" Then
UserForm1.Show
End If
End Sub

--

Regards,
Nigel
(E-Mail Removed)



"James" <(E-Mail Removed)> wrote in message
news:2C71A9AC-25E5-473D-A30A-(E-Mail Removed)...
> Hello,
>
> How do I automatically activate a userform when a user selects a specific
> worksheet tab? What's the code for that?
>
> Thank you