| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofilter based upon combo box
A dialog box has two combo boxes one country the other customers. Based upon
the country the user should only be able to the slect the customers of that country how can that be done? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autofilter based upon combo box
It is basically as simple as it sounds. When the selection is made in
combobox1, you loop through your data and fill combobox2 with the appropriate values. Related: Dependent lists - data validation http://www.contextures.com/xlDataVal02.html -- Regards, Tom Ogilvy "Herman" wrote: A dialog box has two combo boxes one country the other customers. Based upon the country the user should only be able to the slect the customers of that country how can that be done? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autofilter based upon combo box
Well Tom thanks,
But how should i do this? Rgds, Herman "Tom Ogilvy" wrote: It is basically as simple as it sounds. When the selection is made in combobox1, you loop through your data and fill combobox2 with the appropriate values. Related: Dependent lists - data validation http://www.contextures.com/xlDataVal02.html -- Regards, Tom Ogilvy "Herman" wrote: A dialog box has two combo boxes one country the other customers. Based upon the country the user should only be able to the slect the customers of that country how can that be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
| AutoFilter based on cell value | Excel Discussion (Misc queries) | |||
| In Excel I need to set up a combo box based on another combo box. | Excel Discussion (Misc queries) | |||
| Combo box values based on other combo box value | Excel Programming | |||
| Link Combo Box to Autofilter argument | Excel Programming | |||
Hybrid Mode
