Re: Help with Combo Box

Tech-Archive recommends: Fix windows errors by optimizing your registry

Why do you feel you need the combobox instead of simply using Autofilter or
Advanced filter on the data ***?

Is it because you want just that data associated with the selected "zone" to
appear on the separate ***?

How much data and what configuration/layout would you looking for?

Might be Ron de Bruin's Easy Filter add-in would help.

http://www.rondebruin.nl/easyfilter.htm


Gord Dibben MS Excel MVP

On Tue, 7 Oct 2008 11:28:00 -0700, jerious
<jerious@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Would this be the best way to do this, or can you think of another way I
should be doing this?

"Sheeloo" wrote:

See http://www.contextures.com/xlDataVal02.html for the solution

"jerious" wrote:

I have a work*** with a bunch of columns of raw data. I want to set up a
combo box on a seperate *** so I can search by one of the columns (labeled
"zones"). When I click on a zone from the combo box, I would like just
information associated with that zone to appear (like a vlookup or by running
a macro to filter the *** by that zone). I am not too familiar with combo
boxes so I am having trouble figuring this one out. Thanks

.

Quantcast