#1
|
|||
|
|||
Excel Vlookup & Data Validation list box with AutoComplete
Hello
I was needing help please on a Excel VBA coding issue. I have this working on another Excel spreadsheet that i had got help sometime back, but i cant seem to figure out the VB coding. I'm not expert by no means and i was hoping that you guys could guide me to fix it. 1. I have attached a sample of the spreadsheet and what i have is (2) Data Validation list boxes under the Site & GL columns. 2. I would like to use the existing Data Validation list boxes and double click these so that it will Auto Complete the text that i'm typing without having to scroll through the entire list 3. I have a Vlookup that auto populates some coding based on site selection. This works but I thought i would add this to the discussion just to let you know what i'm doing. 4. What i did was copy and paste the code from the spread sheet that is working to the attached and if gives me errors during debug. The first error is Quote:
thanks, |
#2
|
|||
|
|||
Did you add the combo box ?
Excel Data Validation Combo box using Named Ranges |
#3
|
|||
|
|||
The combo box may have a different name.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Alternative to a data validation list? | gebobs | Excel | 5 | 08-01-2016 12:28 PM |
Data Validation - List | Webbn111 | Excel | 9 | 03-09-2016 04:30 PM |
Trying to get Data into Validation List according to Client Name and Document Type | Maoz | Excel | 5 | 01-24-2016 01:17 AM |
Data Validation List based on Two Named Ranges | Rich18144 | Excel | 4 | 01-14-2016 04:37 AM |
Conditional data validation (list drop-down) | click4akshay | Excel | 2 | 04-28-2011 01:51 PM |