Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
populate dropdown/combobox on userform with specific values from s
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
populate dropdown/combobox on userform with specific values from s
Check your earlier post.
sam wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
populate dropdown/combobox on userform with specific values fr
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" wrote: Check your earlier post. sam wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
populate dropdown/combobox on userform with specific values fr
We seem to be doing ok in the earlier post. No need to follow up in these.
sam wrote: 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" wrote: Check your earlier post. sam wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform combobox dropdown question | Excel Programming | |||
Userform combobox dropdown question | Excel Programming | |||
Userform combobox dropdown question | Excel Programming | |||
Populate A Userform ComboBox | Excel Programming | |||
Userform ComboBox populate using code? | Excel Programming |