|Subject:||Re: Listboxes are Starting at the Bottom Instead of at the Top!|
|Posted by:||KC Rippstein (kcrippsteinAThotmailDOTcom)|
|Date:||Mon, 29 Jan 2007|
You can "re-create" your lists using an array formula, like
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.
"Arnold" <ericarnol…@yahoo.com> wrote in message
> 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,
Listboxes are Starting at the Bottom Instead of at the Top! posted by Arnold on 28 Jan 2007