Well how do we place the combo box and the list of names on it...

I couldn't find the message/thread you moved it to. Did you change forums, too?

First its not a good idea to piggyback your question on someone else's. This can lead to confusion. You should start a new thread. So I've moved your question to its own thread.

Check Excel Help on combos for specific instructions

Combobox can be created a couple of ways.

The one I use the most often is by Data Validation. Click on the cell, and select Data > Validation.

Validation Criteria - Allow: = List
Source: =

For the source, you can manually enter the list with each item separated by a comma:

dog,cat,bird,lizard,hamster

Or you can put this list on the spreadsheets somewhere in cells, then put in a reference to those cells:

=A2:A5

Does this give you enough to get started? Read up in the Excel help files on Data Validation / List examples.

That was a real help thanks a looot

Hey jbeaucaire... that was the perfect fit... tanku onece again,I tried it it was just what I wanted.. thannnnxx

My pleasure. I use those combo boxes every day.

I'm afraid that is not a ComboBox, it's a Dropdown and can only be located at a cell, a combobox can be given a position on the screen and is much more versatile when it comes to manipulating your worksheet, using a combobox allows you to programmatically have other things happen when a value is selected, be aware that a dropdown has limitations.

Quote:

---

Originally Posted by JBeaucaire

Combobox can be created a couple of ways.

The one I use the most often is by Data Validation. Click on the cell, and select Data > Validation.

Validation Criteria - Allow: = List
Source: =

For the source, you can manually enter the list with each item separated by a comma:

dog,cat,bird,lizard,hamster

Or you can put this list on the spreadsheets somewhere in cells, then put in a reference to those cells:

=A2:A5

Does this give you enough to get started? Read up in the Excel help files on Data Validation / List examples.

---