I have created a worksheet in Excel, the first column of which I would like to populate with names of people.
I want to be able to populate the names in a manner similar to data validation from a list. The list of potential names is quite extensive, so the enhancement to data validation I would like to include is the ability to filter the list by letter input. For example, I want to click in the first cell where a name will appear and have a drop-down box appear. When I enter the letter "s" in the drop-down list, I would like the list to show all the names beginning with "s". When I insert the second letter of the name, such as "m", I would like the drop-down list to be further narrowed to the names that begin with "sm", etc. At the point where the list is narrowed down enough, I want to click on the chosen name and have that name be entered in the cell.
Additionally, with the pressing of the "enter" key, I would like the active cell to advance to the next cell in the column for name input and the process repeat over again.
I have seen the Ozgrid, and it doesn't do what I want to do.
Can anyone help me? I am quite a novice at this, so if I could ask for your suggestions to be remedial I would appreciate it. I'm still quite new to a lot of VBA jargon.
Thank you so much for any help you can provide.
Sincerely,
Mark1011
Bookmarks