fill 2nd Combobox

[mar050703]

I have the following code for my fost combobox;

Private Sub Userform_Initialize()

    Dim ws As Worksheet
    
    Set ws = Worksheets("Employees")
    Set MyRange = ws.Range("A2", ws.Range("A150").End(xlUp))
    
With Me.Employee
.RowSource = ws.Name & "!" & MyRange.Address
.ListIndex = 0
End With

End Sub

I want to now fill out the 2nd combobox so if the 1st says 'Accounts' then the second will give all the names of those in accounts (column B of the above worksheet).

I am not sure where to start

 

[JerryKlmns]

On the click event of your 1st combo, add code that fills the second