ActiveX Combobox VBA not working on Cascading Data Validation

Hello,

I've posted a similar question recently but now I'm facing one last specific problem which now doesn't match my original post title... I hope someone can help me with this.

On my attached file "License Details" tab, cells B32 and down have cascading data validation with below formula.
=OFFSET(Brands!$B$1,MATCH(A32,Brands!$B:$B,0)-1,1,COUNTIF(Brands!$B:$B,A32),1)

Although I have a separate list on tab "Brands," the following code that I'm using for dropdown list formatting isn't working for this column...
I'm assuming this is because it's not a simple range but a dependent, but I don't know how to make the VBA code to apply to this as well.

Any input is much appreciated.

Please Login or Register  to view this content.