Adding and Using a Combo Box

hi...
please help...

im making a supplies inventory. the scenario is

if combox is = to selected supply, it will automatically prompt the prize.

my head hurts analyzing how to do this in excel 2007.

please help, thank you in advance.

Hello, I have the same question that many of you already posted:

How do you copy/paste combo boxes so that the cell link corresponds to the line/position where the combo box is located?

When you copy paste, both the range and target cell remain fixed.

Thank you,

Alvaro.

Sir I'm Using & Lurning Advance Excel Calss Please Help Me

The whole "point" of Combo Boxes, is that, with drop down lists, you can't format the font. This is a real downer when you need to resize columns, but the drop down font remains so teeny tiny, you can't even read what your choices in the list are! With Combo Boxes; however, you CAN manipulate the size, and style of the font. For instance, if you had a list of students that you wanted to alphabetize,and also show what learning group they are in, by the color of the font ex: the "advanced" group in red font, the "meeting standards" group in blue, and the "needs improvement" group in green.

Another great thing about Combo Boxes is that you can drop down a list of more than 8 items. With the Drop List, you are limited to 8 items viewed at a time, so if you have an extremely long list to chose from, it would take forever to scroll through 8 at a time.

One other advantage of Combo Boxes, which, I believe, is truly neat...is that you can choose the option of "autofill". This fills the box with items from the list range based on the letters you are typing. EX: I start typing "A",the box displays "Alabama". I then add an r "Ar" and the box displays "Arizona". Lastly I add a k:"Ark", and the box displays "Arkansas"

Hi There,

I have a Combo box and what I would like to do is whenever I select any value in the Combo box I would like to display that value in a cell in a particular column, how would I be able to do this.

Appreciate all the help

Thanks,

Maybe I'm a little slow here.
I understand the creation steps 100%. What I'm a little backwards on is what is the point of the entire exercise.

If you know "Data Validation", you can create a "pick list" and fill in the correct corresponding answer into designated cells of your database.

The only purpose I see with the Combo box is to create a list, have it return back as text with a corresponding number in a cell not in your database.

Then what? What is my end goal?

Thanks for any clue.

Hello, I have a combo box and it's populated with my list. I'd like this box to appear in many cells within a column. How do I copy the combo box, say in every cell in a particular column? I see above where it states to hold the bottom right to get the + and drag, but that just expands the box over multiple columns and not put a separate box in each cell. thank,

Once you have your first combo built the way you want it, hold the bottom right of the combo box to get the "+" sign. Hold that and drag it down to fill in as many rows as you need. If you (like me) tested your first box and it has a value in it, just delete the value so it is blank, then pull the blank box down. Hope that works for you!

Hi folks,

Great tool this (Combo boxes) but does one apply this to several cells under each other, without have to repeat the whole process. Copy paste does not work, as it simply applied the same value to the pasted cell. I may need to apply combo boxes to lots of cells next to other, and hope even another tool may be available.
Thank you
Ingrid