Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is it possible to get formulas to equal certain object values in E
So I have a combo box with 11 values in it, I would like a formula to use the
value of the combo box, so lets say, if the value box was "cat" then the formula would act as if it were using cat in the formula... Is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is it possible to get formulas to equal certain object values in E
Hi!
You can link the combobox to a cell and then base the formula on that linked cell. The linked cell will display the NUMBER of the selection. For example, suppose your cb contains these items: dog pig cat frog If you select cat from the cb the linked cell will return 3 because cat is the third item in the list. If you select dog the linked cell will return 1. What do you want to do with your formula? Biff "havocdragon" wrote in message ... So I have a combo box with 11 values in it, I would like a formula to use the value of the combo box, so lets say, if the value box was "cat" then the formula would act as if it were using cat in the formula... Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number of values equal to MAX of a column | Excel Discussion (Misc queries) | |||
copied formulas paste as values | Excel Discussion (Misc queries) | |||
How do I clear data values wthout losing the formulas? | Excel Worksheet Functions | |||
How to add equal values and than replace them with their sum? | Excel Worksheet Functions | |||
#N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel |