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