http://www.teachexcel.com/excel-help/ev.php?i=121128
Further to the question and answers in the thread, link above, regarding Userform Dependant Combobox.
Excellent answer, it does exactly as requested. I am new to forums and am trying to expand my knowledge.
I am trying to do the same sort of thing but with dynamic ranges, variable number of options in each combo box and a group of 4 combo boxes. I.e. one result cascades to the next combo box making sure that an inappropriate result cannot be entered on the userform.
Before trying to work out the code I am working on the excel dynamic ranges using ‘Match’ from the first option to provide the offset reference point for the second ‘Match’.
'=OFFSET((CELL("address",INDIRECT(CONCATENATE("R",ROW($KJ$31)+((MATCH($JQ$25,$KI$32:$KI$131,0))),"c",COLUMN($KJ$31)),FALSE))),MATCH($KJ$26,$KJ$32:$KJ$131,0),4,COUNTIF($KJ$32:$KJ$131,$KJ$26),1)
This may be a too complex solution. Perhaps nested 'Match' does not work in excel.
If this does not work I can go back to creating each option list separately, which may be simpler.
I can get four option boxes working sequentially in the excel workbook. However, I am trying to move all user interfaces to userforms.
I know there are effectively two questions here but I am only looking for one solution, which is how to make multiple Userform Dependant Comboboxs of variable length.
All help welcome.
Bookmarks