Hi,

In my userform, i have

Firstname: <DropdownList>

Question:
1. If I want the value of DropDownList to be read from code, how can I do it
via code by hardcoding the entries in combobox_change() function ?
Private Sub ComboBox1_Change()
....
End Sub

2. If I want the value of DropDownList to be read from Column A1:A10 (note
there are redundant value, how to avoid ?)
Example:
A1: Johnson
A2: Stephen
A3: Michael
A4: Daryl
A5: Michael
A6: Johnson
A7: Rebecca
A8: Johnson
A9: Sally
A10: Sally

So the drop down list will actually read from A1: A10 and have only
Johnson
Stephen
Michael
Daryl
Rebecca
Sally


3. After I click OK in the userform, how can I pass the selected value to my
module code ?

Please advise. Thanks

Regards,
Magix