Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
capture filter values from a sheet into a dropdown list in userfor
Hi All,
I want to capture filter values from sheet2 into a Dropdown list in the user form. Is there a way to do this? For eg, I have a column "Tasks" on sheet2 which have values 1,2,3,4,5,6 and each student can have multiple "Tasks" such as.. John: 1,3 Jill: 1,5 jack: 3,5,6 Bill: 2,4,6 and so on... I have this column set as a filter(Behaves like a dropdown on excel sheet), so John will have a Dropdown Filter with values 1 and 3 in "Tasks" column So basically, I want these filter values to be displayed on the form as dropdown menu with 1 and 3 displayed for John. Hope I made it clear Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
capture filter values from a sheet into a dropdown list in userfor
Check your other post.
sam wrote: Hi All, I want to capture filter values from sheet2 into a Dropdown list in the user form. Is there a way to do this? For eg, I have a column "Tasks" on sheet2 which have values 1,2,3,4,5,6 and each student can have multiple "Tasks" such as.. John: 1,3 Jill: 1,5 jack: 3,5,6 Bill: 2,4,6 and so on... I have this column set as a filter(Behaves like a dropdown on excel sheet), so John will have a Dropdown Filter with values 1 and 3 in "Tasks" column So basically, I want these filter values to be displayed on the form as dropdown menu with 1 and 3 displayed for John. Hope I made it clear Thanks in advance -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
capture filter values from a sheet into a dropdown list in use
Hey Dave, to make it clear. Here is and eg of how the data looks on sheet
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 So lets say you select "12" from Roll_No column filter then it will display Tasks Roll_No(filter) 4 12 6 12 So I want this 4 and 6 to be displayed in the dropdown list on userform too 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 se 4 and 6 for my Tasks Dropdown on the userform. Hope I made it clear Thanks in advance "Dave Peterson" wrote: Check your other post. sam wrote: Hi All, I want to capture filter values from sheet2 into a Dropdown list in the user form. Is there a way to do this? For eg, I have a column "Tasks" on sheet2 which have values 1,2,3,4,5,6 and each student can have multiple "Tasks" such as.. John: 1,3 Jill: 1,5 jack: 3,5,6 Bill: 2,4,6 and so on... I have this column set as a filter(Behaves like a dropdown on excel sheet), so John will have a Dropdown Filter with values 1 and 3 in "Tasks" column So basically, I want these filter values to be displayed on the form as dropdown menu with 1 and 3 displayed for John. Hope I made it clear Thanks in advance -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
capture filter values from a sheet into a dropdown list in use
Check your other post.
sam wrote: Hey Dave, to make it clear. Here is and eg of how the data looks on sheet 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 So lets say you select "12" from Roll_No column filter then it will display Tasks Roll_No(filter) 4 12 6 12 So I want this 4 and 6 to be displayed in the dropdown list on userform too 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 se 4 and 6 for my Tasks Dropdown on the userform. Hope I made it clear Thanks in advance "Dave Peterson" wrote: Check your other post. sam wrote: Hi All, I want to capture filter values from sheet2 into a Dropdown list in the user form. Is there a way to do this? For eg, I have a column "Tasks" on sheet2 which have values 1,2,3,4,5,6 and each student can have multiple "Tasks" such as.. John: 1,3 Jill: 1,5 jack: 3,5,6 Bill: 2,4,6 and so on... I have this column set as a filter(Behaves like a dropdown on excel sheet), so John will have a Dropdown Filter with values 1 and 3 in "Tasks" column So basically, I want these filter values to be displayed on the form as dropdown menu with 1 and 3 displayed for John. Hope I made it clear Thanks in advance -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capture values from a web page drop-down list | Excel Programming | |||
Filiter and Limit selection in Combo box / List Box in the UserFor | Excel Worksheet Functions | |||
Filiter and Limit selection in Combo box / List Box in the UserFor | Excel Programming | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
how do I filter a list of items based on values in another sheet | Excel Discussion (Misc queries) |