Combo Box with options depanted of another combo box.

[MariaPap]

Hello

I have a list with customers in column E. In column F i have their area.

What i need is when i choose an area of a combo box in my userform, then the next combo box to gives me the option to choose ONLY the customers of this area.

How can i do this?

Thanks in advance for any suggestion.

[Tinbendr]

Please Login or Register  to view this content.

[MariaPap]

Thank you.