Gazza83
asked on
Worksheet macro code help
I have four list boxes on my spreadsheet, basically when a value is selected in the first one, I want the remaining ones to filter out and only display what is in the corresponding table on sheet 2
So one example...
Area = Password
Problem = Requires Password
Auto Reset Failed
Process manual reset
No security info supplied etc
So basically the set text selected determines what is displayed in the subsequent list boxes.
Please can you help as I don't possess the necessary expertise.
Many thanks
Gary
So one example...
Area = Password
Problem = Requires Password
Auto Reset Failed
Process manual reset
No security info supplied etc
So basically the set text selected determines what is displayed in the subsequent list boxes.
Please can you help as I don't possess the necessary expertise.
Many thanks
Gary
ASKER
Sorry everyone, forgot to attach it
Book3.xls
Book3.xls
I do have something similar to this:
My example has multiple salesmen with multiple programmes. I ahve a dropdown box that allows me to choose Salesman and then a second dropdown box to select the Sales Programme related to that Salesman.
Does that sound like what you need? My Excel is currently doing a major calc so can't open the file but will do as soon as I can. Can't remember of top of my head how I did it.
Cheers
Rob
My example has multiple salesmen with multiple programmes. I ahve a dropdown box that allows me to choose Salesman and then a second dropdown box to select the Sales Programme related to that Salesman.
Does that sound like what you need? My Excel is currently doing a major calc so can't open the file but will do as soon as I can. Can't remember of top of my head how I did it.
Cheers
Rob
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Rob,
Thanks for your advice...
Yes I was hoping to follow the same sort of principle as a drop down menu option, but was hoping to use list boxes so that it would negate the repetitiveness of a drop down menu.
Basically the first list box would set the president and determine what would appear in list box 2 and 3 etc.
Thanks for your advice...
Yes I was hoping to follow the same sort of principle as a drop down menu option, but was hoping to use list boxes so that it would negate the repetitiveness of a drop down menu.
Basically the first list box would set the president and determine what would appear in list box 2 and 3 etc.
Can you post your workbook. There is not enough information given to form a solution.
Kyle