Combo Box Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GastonFranzini@gmail.com - 28 Nov 2006 18:24 GMT

I need a combo box, to be filtered by another combo box,
In one I'll have surnames, and in the other names, E.G.

code Surname Name
1 Pan Peter
2 Doe John
3 Him Susan
4 Pan Paul

I need a combo box to display surnames, then the other I want to
display the names acording to the surname, and finally I want to store
the code in Cell B15

Thanks

Reply to this Message

Debra Dalgleish - 29 Nov 2006 05:32 GMT

If you can use data validation instead of combo boxes, you may be able
to adapt the technique show in the sample file here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0037 - Dependent Lists Country City'

> I need a combo box, to be filtered by another combo box,
> In one I'll have surnames, and in the other names, E.G.
[quoted text clipped - 10 lines]
>
> Thanks

Signature

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

Reply to this Message

GastonFranzini@gmail.com - 29 Nov 2006 13:23 GMT

Thanks, but the list I have cant be ordered, and I need to show unique
values on the fist validation and on the second, I can?t order the
columns as in the example.
Thanks

Debra Dalgleish ha escrito:

> If you can use data validation instead of combo boxes, you may be able
> to adapt the technique show in the sample file here:
[quoted text clipped - 22 lines]
> Contextures
> http://www.contextures.com/tiptech.html

Reply to this Message