Combo box question

[Guest]

Hi I want to create a combo box and I want it to list values from a specific
column.

I'm making a price list so that I can use a filter process to get the right
product. In this case it's for printed envelopes

Every value apperas several times and I want it to filter the values.

Lets say I choose the size "A4", I want it to choose all rows with "A4" i
column A and then I want to be able to add a new combo box that lists the
values in column B, lets say it's the number of colours on the print.
"2-colours", then I want it to list all A4 envelopes with a 2-coluur print.

 

[Dave Peterson]

It sounds a lot like you want to reinvent Data|Filter|Autofilter.

If you've never used it, Debra Dalgleish has some nice instructions at:
http://www.contextures.com/xlautofilter01.html

Heck, even if you have used it, the instructions are still nice!

 

[Guest]

Hi Dave, that's almost right. The difference is that I want to put the
controls (drop lists) at another place, not directly above the column in
question, I want to be able to place it myself and in autofilter you also get
(i don't exacly know what it says in english since I have a swedish version)
show all and show empty and so on, I just want the values that are in the
column.

/regards Freddie

 

[Cesar Zapata]

I think you want data validation.

you'll find it in the same site as Dave said.
http://www.contextures.com/xlDataVal01.html.


Cesar Zapata

 

[Dave Peterson]

John Walkenbach shows how to get a nice unique list (but for a listbox--but you
could change that to a combobox) at:

http://j-walk.com/ss/excel/tips/tip47.htm

Then you could record a macro when you apply filtering. That should get you
started.