I have created a spreadsheet that would allow users to select for a list
(ComboBox from Forms Toolbar). I want to be able to take the data in the
field (ComboBox) and use it in a formula (COUNTIF(A2:A98,I2)) where I2 is a
vendor name.

If I enter the data into Cell A2 manually the formula works. If I add the
combo Box it does not. How do I capture the data from the Combo Box to use in
the formula?

Any help is appreciated.
--
Brooks W.