Listboxes are Starting at the Bottom Instead of at the Top!

[Arnold]

Good Day,
I have a question as to why all of my listboxes, when clicked, display
the first blank data (after the last alphabetical text), requiring a
user to scroll up instead of scroll down. How can the listbox always
start with top ("A") record.

The listbox is getting its values from a source column containing data
that is pasted into the column with code (different filtering macros
create different lists in this column).

Thank you,
Eric

 

[KC Rippstein]

You can "re-create" your lists using an array formula, like
=INDEX(A:A,SMALL(ROW($2:$1000),ROW(2:2)))
and don't forget to Ctrl+Shift+Enter to commit the array formula.
Then drag this formula down as far as you need. It will copy the list to a
new location in sorted order, and you can name this new sorted range as the
actual range to use instead of the original one.