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
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 would suggest to use Data Validation list for this as it can be easily copied down or across preserving the same settings.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks