View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
roadkill roadkill is offline
external usenet poster
 
Posts: 173
Default 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