Probably easier to use Data=Validation with the List option to get a
"combobox" in the cell (the dropdown arrow only appears when you select the
cell).

Debra Dalgleish has a lot of information on this:

Debra Dalgleish
http://www.contextures.com/tiptech.html

one example page from the index:
Datavalidation - top
http://www.contextures.com/xlDataVal01.html

You will need to have the list of names on one sheet. If it isn't on the
sheet with the data validation, you will have to create a defined name to
point to it (insert=Name=Define
name: List1
RefersTo: =Sheet2!$A2:$A50

then in the data validation text box for source after you select list, put in

=List1

--
Regards,
Tom Ogilvy




"Loni - RWT" wrote:

When it comes to combo boxes and coding and whatever else is supposed to be
going on, I know nothing about it. So pardon me if I don't sound very
intelligent. Here's what I want to do: I have a workbook with multiple
input sheets and one report sheet where all my data is being calculated. On
my report sheet, I want to put a combo box to choose different employees.
Based on the selection that is chosen, I then want it to pull certain
information from one of the various input sheets. I went to the control
toolbox and inserted a combo box. Now What????
I have tried to figure out how to put names to select from in the combo box,
but nothing seems to work. I've read thru several of the threads here, but I
haven't seen anything that I think particularly helps me out. Can anyone
give me any insight?
Thanks!!