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!!

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!!

Well you can try this. Set up the combo box, right click it and go to Format
Control. Where it says Input Range, highlight the employee names or create a
named range for the employees names.

In the Cell Link, put this next to the employees list. This cell will tell
you what item has been chosen out of the combo box.

Using this Cell Link number you can now use Offset/Vlookup/Match, etc
formulas to come up with the individual employees information.

Let me know if you have any more questions.

"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!!

Since the OP doesn't seem that familiar with Excel comboboxes, this describes
the Dropdown/Combobox from the Forms toolbar (rather then the Control Toolbox
Toolbar).

--
Regards,
Tom Ogilvy


"AKphidelt" wrote:

> Well you can try this. Set up the combo box, right click it and go to Format
> Control. Where it says Input Range, highlight the employee names or create a
> named range for the employees names.
>
> In the Cell Link, put this next to the employees list. This cell will tell
> you what item has been chosen out of the combo box.
>
> Using this Cell Link number you can now use Offset/Vlookup/Match, etc
> formulas to come up with the individual employees information.
>
> Let me know if you have any more questions.
>
> "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!!