By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Filter Combo box from another

100+
P: 112
Hi,
I need to filter from one combo box to another in MsExcel. I have two combo box. one is Categary and another is product. If the user select categary depend on that second combo box filter only product which belongs to the categary. I m really sorry i don;t where to post for Excel Question, so i posted here.
Nov 27 '06 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,616
Here is good for Excel questions - don't worry.
However, your question is lacking in detail. It would be a lot easier to answer if you provided the sort of information we'll need to answer it.
I'm guessing you have a form in your Excel spreadsheet.
What are the ControlSources of your combo boxes?
How is your data laid out (what do you have in your columns)?

Basically though, your options are :
1. Create a new set of data when the first ComboBox is changed (every time) and use this as the ControlSource of the other.
2. Set the second ComboBox ControlSource as a list and recalculate it every time ComboBox 1 is changed.
Nov 27 '06 #2

100+
P: 112
Here is good for Excel questions - don't worry.
However, your question is lacking in detail. It would be a lot easier to answer if you provided the sort of information we'll need to answer it.
I'm guessing you have a form in your Excel spreadsheet.
What are the ControlSources of your combo boxes?
How is your data laid out (what do you have in your columns)?

Basically though, your options are :
1. Create a new set of data when the first ComboBox is changed (every time) and use this as the ControlSource of the other.
2. Set the second ComboBox ControlSource as a list and recalculate it every time ComboBox 1 is changed.
Can u explain more detaily,
I have one combo box for the department. Its Perfect. Second combo contain the Name of the employee. It should filter only selected department employee. For the second combo box i have the data its contains employee name and second field their depart. This details in the another worksheet.
Nov 28 '06 #3

NeoPa
Expert Mod 15k+
P: 31,616
It seems clear to me.
I can't explain any better until I know what you can and can't understand.
Obviously you'll have to look at your options to see what can be supported in Excel and how first. We're not here to do it all for you but just to point you in the right direction and answer specific questions.
Nov 29 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.