Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expected:expression
I tryed that and now I get the following error:
Compile error Syntax error I would appericiate any further help. Thanks. -----Original Message----- Change Worksheets("Home").Range("C8:C27").Sort Key1: = Worksheets("Home").Range("C8") XlSortOrder.xlAscending to Worksheets("Home").Range("C8:C27").Sort Key1: = Worksheets("Home").Range("C8"), Order1:= xlAscending -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Capinvest" wrote in message ... I am trying to sort a combobox alphabetically in excel using vba. I have the following code behind the combobox: Private Sub ClientList_Change() ' this sorts the names alphabetically Worksheets("Home").Range("C8:C27").Sort Key1: = Worksheets("Home").Range("C8") XlSortOrder.xlAscending End Sub I get an error everytime I try to run it. The error says: Compile error: Expected:expression I would appericate any help with this issue. . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
value expression | Excel Worksheet Functions | |||
need help with expression | Excel Discussion (Misc queries) | |||
Expression | New Users to Excel | |||
Expected end of Statement | Excel Worksheet Functions | |||
Expression for Macro - help | Excel Discussion (Misc queries) |