| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo box - input Range
Do you have to use a combobox?
How about a cell with Data|Validation? Then you could use List with a source: =INDIRECT(IF(width=0.7,"range1","range2")) (notice that the range1 and range2 names are surrounded by quotation marks.) PCH wrote: I have a combobox on a work sheet. I want to set the input range depending upon an if statement... Input range =if(Width=0.7,Range1,Range2) typing this statement into the input range does not work. How can I achieve this? regards Wayne -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Input range | Charts and Charting in Excel | |||
| Combo Box input range automatic update | Excel Discussion (Misc queries) | |||
| combo box range - row | Excel Discussion (Misc queries) | |||
| How can I calculate user input from a combo box into a formula? | Excel Worksheet Functions | |||
| Variable Input Range for Combo Box | Excel Worksheet Functions | |||
Threaded Mode
