Ethan
09-17-2011, 01:05 AM
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.
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.