ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Dropdown list key selection (https://www.excelbanter.com/excel-discussion-misc-queries/48296-dropdown-list-key-selection.html)

TrevorM

Dropdown list key selection
 
Hi

Is it possible to format a dropdown list in such a way that if you press a
letter key while the list is open it will bring to the first entry in the
list beginning with that letter? The feature exists with autofilter and the
list behind the dropdown is sorted alphabetically

Dave Peterson

You could use a combobox from the control toolbox toolbar (not from the Forms
toolbar).

TrevorM wrote:

Hi

Is it possible to format a dropdown list in such a way that if you press a
letter key while the list is open it will bring to the first entry in the
list beginning with that letter? The feature exists with autofilter and the
list behind the dropdown is sorted alphabetically


--

Dave Peterson


All times are GMT +1. The time now is 02:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com