Combobox linked to Listbox

[Ethan]

Hello all,

I am working on a userform that is linked to a Listbox.
By selecting a record from the listbox and hitting the "EDIT"-button the userform can be accessed.

At this moment the user is able to edit the values of textboxes and save it.
However I like to use a combobox for the "post"
The range from which the user can choose should be M2:M
when saved it should be stored in range L:L on sheet "Database"

Important is that when the userform is called again it initializes the chosen "post".

I hope this all make any sense.

[Bob Phillips]

Just change it to a combobox, and set the RowSource to M2:M6.

[Ethan]

Just change it to a combobox, and set the RowSource to M2:M6.

Thanks xld, that solved the "populate combobox" part.
But how do I initialize it with the selected item from the listbox?

[Ethan]

Perheps someone else?

[Bob Phillips]

In the initialise

[vba]
ComboBox1.ListIndex = -1[/vba]