Re: sort problem

May I suggest the microsoft.public.excel.programming newsgroup. The newsgroup you're in is
for Access.

--
Wayne Morgan
Microsoft Access MVP


"capinvest" <(E-Mail Removed)> wrote in message
news:020c01c35870$17469930$(E-Mail Removed)...
> 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. I would
> appericate any help with this issue.