autofilter based upon combo box

[Herman]

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?

[Tom Ogilvy]

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?
>

[Herman]

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?
> >