dynamic combo box excel with a difference

[johnbird1988]

Hello

I have set up the validation boxs where one value depends on another. This works fine and is done by using the:

=INDIRECT(VLOOKUP($C6,SMSSC,2,FALSE))
[CODE/]
 
The problem is  would like to use the same prinsibles in two combo boxs.
 
I have setup ComboBox1 list of value but having trouble with the sec box
 
How can I translate the =INDIRECT(VLOOKUP($C6,SMSSC,2,FALSE)) into VBA code i know i will need to change the "$C6" to ComboBox1.value
 
Please help need to get something together for tomorrow
 
Thank you
 
John