ComboBox Population of Cell Range

[Phil Hageman]

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

 

[Phil Hageman]

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")),Variables!D8,"Select Strategy"

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