Show listbox items based on combobox selection, then place listbox selections to bookmark.

[park62]

I'm wanting to create a multi-column listbox for my userform, which displays a particular list of items based on a selection from a combobox.

Once the item/items have been selected from the listbox I then want the contents of one column placed at one bookmark then the contents of another placed at a different bookmark.

So the combobox contains names: Council1, Council2, Council 3, Council4. Then I want the listbox to display certain items based on which Council is selected. The items will have a few columns but I'm hoping to hide those, as each item column has different wording for that item (which will hopefully get placed at a particular bookmark).

Has anyone had a similar situation like this?

Thanks in anticipation

 

[Andrzejek]

How about this to start:

Option Explicit

Private Sub UserForm_Initialize()

With ComboBox1
    .Style = fmStyleDropDownList
    .AddItem "Council1"
    .AddItem "Council2"
    .AddItem "Council3"
    .AddItem "Council4"
    .ListIndex = 0
End With

End Sub

Private Sub ComboBox1_Click()
MsgBox "Fill listbox with " & ComboBox1.Text & " information."
End Sub

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.