Userform Dependant Combobox - can't get cbo2 to show list based on cbo1 inpt

Great -Work great.

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.

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)

Reference for offset based on first selection = ____
Match of data second option = ____
Number of items in second option = _____

If this does not work I can go back to creating each option list separately, which may be simpler.

I can get for 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.

All help welcome.

Thanks for your help. I have started an new thread called Userform Dependant Combobox