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 - 29 Jan 2007 22:40 GMT
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.
> Good Day,
> I have a question as to why all of my listboxes, when clicked, display
[quoted text clipped - 8 lines]
> Thank you,
> Eric