_Rob_ Posted April 30, 2007 Share Posted April 30, 2007 I wish to create a a number of combo boxes or drop down lists using data validation, when an item in a combo box is selected, the next combo box has a list of items specific to the choice in the first combo box. IE: combo box 1 = window = wall = door = roof window is selected. combo box 2 = glass = frame = beading = handle glass is selected. combo box 3 = single glazed = double glazed If roof was selected in combo box 1, then the other combo boxes would show other specific option. Hope that makes sense.. Can anyone help?? Link to comment Share on other sites More sharing options...
mikeyb10supra Posted April 30, 2007 Share Posted April 30, 2007 I wish to create a a number of combo boxes or drop down lists using data validation, when an item in a combo box is selected, the next combo box has a list of items specific to the choice in the first combo box. IE: combo box 1 = window = wall = door = roof window is selected. combo box 2 = glass = frame = beading = handle glass is selected. combo box 3 = single glazed = double glazed If roof was selected in combo box 1, then the other combo boxes would show other specific option. Hope that makes sense.. Can anyone help?? Sounds like your going to need some VBA forms for that mate, I will have a think about it tonight but im a little busy at the mo....can it wait Link to comment Share on other sites More sharing options...
razza Posted April 30, 2007 Share Posted April 30, 2007 Where the box links to a list, have that list lookup from a seperate list with lots of IF statements, i.e. if cell = Window, return "x" values, if cell = door then return y value etc etc. Might be a way round it....hope that makes sense, sneaking this in at work so can't take too long lol! Link to comment Share on other sites More sharing options...
couv3z Posted April 30, 2007 Share Posted April 30, 2007 This may not be helpful as it seems you want to do it via a drop down thing!!! but there its another using a table and If statements, if you want i can knock up dummy one for you, and e-mail you it??? let me know via a PM Link to comment Share on other sites More sharing options...
MrHanky Posted April 30, 2007 Share Posted April 30, 2007 Damn it, this sort of thing is so easy in Access but in Excel I am struggling as I always use Access. I will persevere though and try and help. Mark Link to comment Share on other sites More sharing options...
_Rob_ Posted May 1, 2007 Author Share Posted May 1, 2007 I was originally thinking IF's and VLOOKUP, but how would i get the lookup or IF's to work in the drop down? Could i have the range for the drop down as a number of IF statements, and these IF's change according to the selection in the previous drop down? Link to comment Share on other sites More sharing options...
mikeyb10supra Posted May 1, 2007 Share Posted May 1, 2007 I was originally thinking IF's and VLOOKUP, but how would i get the lookup or IF's to work in the drop down? Could i have the range for the drop down as a number of IF statements, and these IF's change according to the selection in the previous drop down? they wont work in the dropdown...I have had a think about this and think you should create separate formulas maybe on the far right hand side of the sheet so they cant be seen by the user and use if's on the cell value in the dropdown lists....set all the lists up first though Link to comment Share on other sites More sharing options...
MrHanky Posted May 1, 2007 Share Posted May 1, 2007 OK, here is something to build on I think. Sorry its not great but im at work and I don't know Excel that well. See how it goes and post up if you need help as I don't mind learning this stuff as we go. To see how this is working you need to click on the top left icon of the Control Toolbox "Design Mode". This allows you to right click on one of the drop downs and select "View Code". All it is then is a series of If statements in VBA. Hope this helps and sorry its not great Mark Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now