Is it possible to get formulas to equal certain object values in E

[havocdragon]

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?

[Biff]

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" <havocdragon@discussions.microsoft.com> wrote in message
news:52D857F6-2AC8-4A98-9ACF-4EDAAD020B78@microsoft.com...
> 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?