Excel - capture filter values from a sheet into a dropdown list in userfor

Asked By sam on 16-Sep-09 03:36 PM
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

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 replied on 16-Sep-09 03:48 PM
Check your other post.


--

Dave Peterson
sam replied on 16-Sep-09 04:53 PM
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 replied on 16-Sep-09 06:33 PM
Check your other post.


--

Dave Peterson