ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Alphabetical List Box (https://www.excelbanter.com/excel-discussion-misc-queries/183777-alphabetical-list-box.html)

roadkill

Alphabetical List Box
 
Hello,

I have a Data Validation List Box that I put in some blank spaces at the end
as I anticipate the list increasing over time. Anyway, when a user accesses
the list box, it always starts at the bottom with the empty fields. Is there
a way to force it to open at the top, which is alphabetized? I already have
the Ignore Blanks box checked.

Thank you


All times are GMT +1. The time now is 10:24 PM.

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