View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike C[_5_] Mike C[_5_] is offline
external usenet poster
 
Posts: 24
Default Code to automatically sort a list, each time that a new entry isadded to the bottom of the list

Hello - I am wondering if anyone could provide me with code that will
re-sort a list, each time a user places a new line at the bottom of
the list.

So, for example, in column A, rows 1-10, I have a list of names, which
are sorted descending. When a new name is added to row 11, and the
user clicks out off of the cell or presses enter, I am hoping the
column can automatically resort.

Thanks for any suggestions.