| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activate userform when a worksheet tab is selected
Hello,
How do I automatically activate a userform when a user selects a specific worksheet tab? What's the code for that? Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
activate userform when a worksheet tab is selected
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 "James" wrote in message ... Hello, How do I automatically activate a userform when a user selects a specific worksheet tab? What's the code for that? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform causing a slip for Worksheet activate? | Excel Programming | |||
| How do I activate the next cell in a selected range? | Excel Programming | |||
| Mscal.ocx on a UserForm to return selected date to WorkSheet | Excel Programming | |||
| Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
| Activate button when row selected. | Excel Programming | |||
Linear Mode
