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 |
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) |