Data Validation Combo Box with Multiple Independent Validation Lists

[firstofnine]

I am trying to create a spreadsheet wherein I can select the following independent data (held in columns). Vendor, Account and Class. In my current workbook these are in Columns H, I and J respectively. I have the lists for each set up on a separate sheet and have defined names for each.

Data Validation alone would work, however my Vendor List has 1000+ entries and my account list 100+ entries. Simply too much for scrolling through the lists. The Contexures "Excel Data Validation Combo box Click" code (see below) works to allow autofill on the list, however, I then cannot use data valuation in the other two data sets as any data valuation cell triggers the combobox related to whichever dataset I choose to link to the combobox. Any suggestions?


Thanks!
Christina

Here is the Contextures code to make it easier to answer:
'=========================================

Please Login or Register  to view this content.

'====================================

[JBeaucaire]

You can restrict what code is executed based on the COLUMN.

Please Login or Register  to view this content.