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?

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?

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?