Combo Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Seti - 25 Aug 2006 00:47 GMT

Is there a way that when you choose a field in a combo box you can use
that in a formula? I have 9 different options in the combo box and I
want to tie each option to a number and have the number associated with
that option to show up in another cell. Any suggestions?

Thanks!
Renee

Signature

Seti

Reply to this Message

Max - 25 Aug 2006 07:07 GMT

Assuming you're referring to a forms combo box (drawn from the forms
toolbar), just right-click on the combo box > Format Control, and then point
the cell link to a desired cell, say: A1. The numbers: 1,2,3 ... 9 will
appear in A1 corresponding to the selection made in the combo box droplist:
top item - 1, 2nd item - 2, and so on

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

>
> Is there a way that when you choose a field in a combo box you can use
[quoted text clipped - 4 lines]
> Thanks!
> Renee

Reply to this Message