ukdane
03-02-2009, 12:43 AM
If I have a listbox on a worksheet, which has been generated using the List option in Data Validation, how can I get it to automatically scroll throught the alphabet.
For example if I have a list the contains 10 items, and the eight item is "Mars" If the user activates the cell, and then begins to type M (it rolls down to words that start with M.
If the user then types A, it rolls through to words starting with MA.
And so on and so forth.
At the moment this isn't an option, how can I get the listbox to do this?
(Using Excel 2003)
Note this is on a worksheet, not a listbox on a form.
For example if I have a list the contains 10 items, and the eight item is "Mars" If the user activates the cell, and then begins to type M (it rolls down to words that start with M.
If the user then types A, it rolls through to words starting with MA.
And so on and so forth.
At the moment this isn't an option, how can I get the listbox to do this?
(Using Excel 2003)
Note this is on a worksheet, not a listbox on a form.