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. |
All times are GMT +1. The time now is 02:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com