Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am making a userform that i need help with. What i want is when the user
selects the radio button called LS338, a tab in the mutlitab called LS338 (i can change this if that is a problem) will show. Also when i select radio button LS518 tab LS518 shows, and ect. The Multitab is called LinkBelt. What is the code that i need to do this? i was thinking something like LinkBelt.LS338.show LinkBelt.LS338.select but these give me errors. Anyone know? Thanks in advance Jared |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Since I don't know what your page names are one your MultiPage (unless you
meant tabstrip). Private Sub LS338_Click() If LS338.Value Then For Each p In Me.Linkbelt.Pages If LCase(p.Caption) = "ls338" Then l = p.Index Exit For End If Next Linkbelt.Value = l End If End Sub -- Regards, Tom Ogilvy "CSUS_CE_Student" wrote: I am making a userform that i need help with. What i want is when the user selects the radio button called LS338, a tab in the mutlitab called LS338 (i can change this if that is a problem) will show. Also when i select radio button LS518 tab LS518 shows, and ect. The Multitab is called LinkBelt. What is the code that i need to do this? i was thinking something like LinkBelt.LS338.show LinkBelt.LS338.select but these give me errors. Anyone know? Thanks in advance Jared |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add tabs to multipage in userforms | Excel Discussion (Misc queries) | |||
place pictur underneath tabs on multipage | Excel Programming | |||
multipage form | Excel Programming | |||
multipage tabs off? | Excel Programming | |||
Pictures or colors on tabs of multipage? | Excel Programming |