Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox - Sorting Data
Sub SOR()
I have a combobox - when I choose an option it arranges data according to Client which is currently in column G, however I need to sort data according to "Client" irrespective of the Column, how do I tinker with the code below to do this - Thanks ' SOR Macro ' Macro recorded 20/02/2005 by _ _ ' ' Range("C9:AS69").Select Selection.Sort Key1:=Range("G9"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox - Sorting Data
Key1:=Range("G9"),
specifies to sort on column G. If you want to sort on some other column, change Key:= to point to another column in the data. -- Regards, Tom Ogilvy "teresa" wrote in message ... Sub SOR() I have a combobox - when I choose an option it arranges data according to Client which is currently in column G, however I need to sort data according to "Client" irrespective of the Column, how do I tinker with the code below to do this - Thanks ' SOR Macro ' Macro recorded 20/02/2005 by _ _ ' ' Range("C9:AS69").Select Selection.Sort Key1:=Range("G9"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox data | Excel Worksheet Functions | |||
Sorting dates in a combobox | Excel Programming | |||
Sorting Items in a ComboBox? | Excel Programming | |||
Update Combobox with New Data | Excel Programming | |||
Sorting in a ComboBox | Excel Programming |