Combo update filtering

P

Profairy

I have the same problem. I need my combo boxes to update each other.
have 6 combo boxes and as i select criteria i want it to filter th
records so as to limit the choices in the following combo boxes... i
this possible like it is in access????

Your help would be much appreciated :0)

Helen
 
T

Tom Ogilvy

You might want to look at the built in Autofilter capability under
Data=>Filter=>Autofilter.
 
P

Profairy

Hi,

Thanks for the link and the tips... I'm trying to find the VBA code t
run a macro to do this for me. Any ideas? My combo boxes are on a use
form. I don't want our users to be able to access the excel data sheet
directly and i'm trying to do it all via GUI forms.

Hele
 
T

Tom Ogilvy

Again,
Having your code apply an Autofilter might be way to go. You can get that
code by turning on the macro recorder and applying the filter yourself. You
can not get the lists from the autofilter, but you can use special cells,
looking at the visible cells to get a listing of conditional values to
display.

John Walkenbach shows how to get a unique, sorted list using a collection
and a bubble sort:

http://j-walk.com/ss/excel/tips/tip47.htm
Filling a ListBox With Unique Items
 
Top