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:
'=========================================
'====================================
Bookmarks