Hi All,

How can I capture values from a sheet and populate a combobox with those
values?

For eg: I have a sheet with following values:

Tasks Roll_No
3 11
5 11
4 12
6 12
2 13
5 13
3 14
4 14
1 15
2 15
1 16
4 16

Now I have a userform with a textfield "Roll_No" and a Combobox "Tasks".
How can I populate "Tasks" dropdown / combobox on the userform once I input
a value in Roll_No field.

For eg: If I input "12" in "Roll_No" field, I want the "Tasks"
Dropdown/combobox to autopopulate with "4" and "6" only.

Is there a way to capture filter values(4 and 6) from a sheet to a userfrom.
So when I input "12" on userform textbox I see 4 and 6 for my Tasks Dropdown
on the userform?

Hope I made it clear

Thanks in advance