excel colum in alphbetical order
 

How do I set up an excel colum so it enters all the information in
alphbetical order?

excel colum in alphbetical order
 

You cannot format a column to sort.

You have to use event code in the sheet module.

Right-click on your sheet tab and "View Code"

Copy/paste this code into that module.

Private Sub Worksheet_Change(ByVal Target As Range)
Columns(1).Sort Key1:=Range("A1"), Order1:=xlAscending, _
Header:=xlGuess, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom
End Sub

As you enter data in column A it will sort.


Gord Dibben MS Excel MVP



On Tue, 1 Aug 2006 13:29:02 -0700, Excel questions <Excel
wrote:

How do I set up an excel colum so it enters all the information in
alphbetical order?