Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofill with best match
Here's my scenario:
I'm using data validation to create drop downs in a spreadsheet that will be filled out by the user moving from cell to cell. The powers that be would like for the cell to either autocomplete with the best match (as a combobox control would do) or at the very least, jump down in the list to the first entry beginning with the letter the user types. I'd like to do this without putting a in control in place of the cell. Does anyone know code that would give a cell this functionality? I'm guessing it'll just have to be a change event that looks up the value in the cell, but I'm hoping for an alternative. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
Autofill Match Formula on different worksheets | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Q. Autofill question: Can I autofill alpha characters like I can numbers? | Excel Programming |