Quote Originally Posted by snb View Post
To add to the 'neat' requirement see the attachment
That is another way to approach it, for sure, but personally, I do not like it. The automatic selection of the item when it is the last remaining item is kind of disconcerting to me, especially if I (unknowingly) mistyped the letter that made the entry unique and the dialog box disappears... kind of leaves me wondering. Of course, maintaining the last entry on calling up the control the way you do helps mitigate this, but then that feature forces you to delete the entry in the edit field the next time you call the control up to look for a sheet with a completely different spelling. I see you handled that by having the Left Arrow Key erase the entry, but that changes the functionality I implemented allowing you to hit the Left Arrow Key and continue editing the text in the edit field (in case you mistakenly entered the ListBox and want to return to the edit field). You also killed off the Enter Key as a selector... if I am using the arrow keys to move up or down in the ListBox, the natural thing to do is hit the Enter Key when I have the item I want selected because my hands are on the keyboard. As I said, the above are my own personal feeling, but I do appreciate your posting your version of the "Go To Sheet" selector as I am sure it will appeal to others who read this thread, so it is good that you made it available.