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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 06:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com