Populate active x combo box to multiple cells

Is there an easy way to populate an active x combo box so that it works throughout a worksheet without having to create a combo box in each cell?

Thank you!

Barbara

Hi Barbara is that the same combobox? same items?

Yes, it is the same combo box just placed in a different cell

I agree with AlKey. Drop-down list could solve your problem.

This link can help you: drop-down list tutorial

Is it you are looking for?

I am not sure that validation will work given what I need. I have 2 columns. One column is an identifier column and one has the information that I want input into the cell. As an example, column 1 contains a list of ingredients. Column 2 contains the cost per ounce of the ingredients. I want to be able to select the ingredient and have it input the cost. Is this possible with validation?

Thank you!

Yes, if you have data validation lists** for ingredient selections running in A2 down
you could use eg an Index/Match to retrieve the cost per ounce in the adjacent col B
Eg in B2, copied down: =IF(A2="","",INDEX(Sheet1!B:B,MATCH(A2,Sheet1!A:A,0)))
where Sheet1 contains the master reference data:
- Ingredient data in col A, Cost per ounce data in col B

**DVs can easily be propagated via copying down, or copy > paste
--------------------------------------------------------------
Any good? Wave it, hit the little star at the bottom left of my responses