populate dropdown/combobox on userform with specific values from s

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
 
D

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top