Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo update filtering
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo update filtering
Go he
http://www.contextures.com/xlDataVal02.html HTH "Profairy " wrote in message ... I have the same problem. I need my combo boxes to update each other. I have 6 combo boxes and as i select criteria i want it to filter the records so as to limit the choices in the following combo boxes... is this possible like it is in access???? Your help would be much appreciated :0) Helen x --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo update filtering
You might want to look at the built in Autofilter capability under
Data=Filter=Autofilter. -- regards, Tom Ogilvy "Profairy " wrote in message ... I have the same problem. I need my combo boxes to update each other. I have 6 combo boxes and as i select criteria i want it to filter the records so as to limit the choices in the following combo boxes... is this possible like it is in access???? Your help would be much appreciated :0) Helen x --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo update filtering
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 -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo update filtering
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 -- Regards, Tom Ogilvy "Profairy " wrote in message ... Hi, Thanks for the link and the tips... I'm trying to find the VBA code to run a macro to do this for me. Any ideas? My combo boxes are on a user form. I don't want our users to be able to access the excel data sheets directly and i'm trying to do it all via GUI forms. Helen --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-filtering based on a value chosen in a combo box? | Excel Discussion (Misc queries) | |||
Combo Box Filtering Macro | Excel Discussion (Misc queries) | |||
Combo Box Filtering Macro | Excel Discussion (Misc queries) | |||
VBA question - Combo box showing result of filtering | Excel Programming | |||
Excel VBA - Multi sheet filtering/querying(?) & combo box woes | Excel Programming |