populate dropdown/combobox on userform with specific values from s

[sam]

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

 

[Dave Peterson]

Check your earlier post.

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

 

[sam]

Hey Dave, Thanks a lot for all you help in getting this to work.

I was working on this and I came across an issue where students input values
in "Roll_No" field that are not present in the sheet. Is there a way where I
can disable the "Tasks" dropdown if they input an invalid "Roll_No" or a
"Roll_No" that is not present in the sheet? So basically enable the "Tasks"
dropdown on form only if the "Roll_No" they input is from the list in the
sheet.

Thanks in advance

 

[Dave Peterson]

We seem to be doing ok in the earlier post. No need to follow up in these.