Listbox 3

From: Tim Coddington (jacod_at_comcast.net)
Date: 07/19/04 

Date: Sun, 18 Jul 2004 18:07:03 -0700

OK. I give up. I have a combobox where the data is sorted and bound to an
excel range like:
        Rows(RowStart% & ":" & RowEnd%).Sort Key1:=Range(Column$ &
RowStart%), Header:=xlYes
        .RowSource = Column$ & RowStart% & ":" & Column$ & RowEnd%
        .ListRows = IIf(.ListCount > 20, 20, .ListCount)
        .DropDown
The above occurs on the selection of the combobox via ._Enter.
When the user selects an item, I record the selection and clear
<unsuccessfully> the combobox .
I have tried .clear, but that only is supposed to be used with .Additem.
And the system tells
    me so; it crashes with an unspecified error.
I've tried .RowSource = "", but apparently, when you do that, .ListIndex
becomes invalid and
    causes another error, and if I try to set it to -1, another error yet.
What is the proper method for clearing a listbox bound to a spread***
range? Is there
something I have missed?