BTW:

I know you was on about option buttons but the above is aimed at using
two comboboxes instead (like drop down choices), slightly easier I
think that having loads of option buttons to hide/unhide

Duncan


Duncan wrote:

Tony:

On the change event of the category combo box something like...

(assuming...first category box is called "CatList" and second item box
is called "Man"...change to suit)


Private Sub CatList_Change()

If CatList.Value = "Cars" Then
Man.Clear
Man.AddItem "BMW"
Man.AddItem "Lexus"
End If

If CatList.Value = "Lorries" Then
Man.Clear
Man.AddItem "Lorry make 1"
Man.AddItem "Lorry make 2"
End If

End Sub

then in the change event of the second box, do something similar to
above to fire the sub you want to fire based on the value in the box
after update

Hope this gets you going

Duncan


Tony wrote:

How do I make the hide/unhide for my selection?