ComboBox Population of Cell Range
 

A Workbook has two worksheets €“ €œBSC Rationale€� and €œVariables€

ComboBox3 on €œBSC Rationale€� has a LinkedCell: Variables!$C$11, which is populated from ListFillRange: Variables!$D$11:$D$16. I need to populate merged cell range K8:AA8 on €œBSC Rationale€� as follows

If Variables!$C$11 = €œT1€� or €œT2€�, then Variables!$D$8, else blank, and
If Variables!$C$11 = €œR1€� or €œR2€� or €œR3€� or €œR4€�, then Variables!$D$9, else blan

How this works €“ user selects a €œT€� or €œR€� value, and the appropriate value appears in K8:AA8

Should this be done by formula or by code in a module

What would the formula/code, be

Thanks
Phi

ComboBox Population of Cell Range
 

These two formulas work. Can they be combined, or should code doing the same thing be used in a module

=IF(((Variables!C11="T1")+(Variables!C11="T2")),Va riables!D8,"Select Strategy"

=IF(((Variables!C11="R1")+(Variables!C11="R2")+(Va riables!C11="R3")+(Variables!C11="R4")),Variables! D9,"Select Strategy")