| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell auto population - why 0 when source cell is empty? | Excel Discussion (Misc queries) | |||
| Automatic cell population | Excel Discussion (Misc queries) | |||
| Userform text & combobox population help required please | Excel Programming | |||
| Show one range in a combobox and write the 2nd range! | Excel Programming | |||
| hyperlink - cell population | Excel Programming | |||
![Phil Hageman[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
