Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i use a combo box or drop down list to preform a calculatio
I want to use a drop down list or combo box to preform a calculation in a
worksheet. IS this possible or can use suggest another way of doing calulations using a numbers that change. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i use a combo box or drop down list to preform a calculatio
"Martin Zelones" wrote:
I want to use a drop down list or combo box to preform a calculation in a worksheet. IS this possible or can use suggest another way of doing calulations using a numbers that change. Assume you have a DV* droplist in A1 which allows a selection of either: 1, 2, 3 Then you could just point at A1 in your formula, for example in say, C1: =IF(A1="","",VLOOKUP(A1,{1,"A";2,"B";3,"c"},2,0)) C1 will evaluate based on the selected value in A1. If "1" is selected in A1, C1 returns "A", "2" returns "B" and so on. If the selection in A1 is cleared (with the Delete key), C1 will appear "blank". *Similarly if you have a forms combo box with the cell link as A1, which drops the values: 1, 2, 3 into A1 based on the selection made -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional drop down list | Excel Discussion (Misc queries) | |||
Drop down list as part of a file name selector | Excel Discussion (Misc queries) | |||
Drop Down List Box, Combo Box | Excel Discussion (Misc queries) | |||
Order of drop down list | Excel Discussion (Misc queries) | |||
re-ordering the list on a filter drop down | Excel Discussion (Misc queries) |