[RESOLVED] Blanking text of a Dropdown List style ComboBox

[Elroy]

This is another one I've struggled with. I like the "Dropdown List" style of a ComboBox for certain applications. However, there are times when I need to "blank" it out. You can't just do cbo.Text = vbNullString, as the .Text property is read-only.

The only way I've found to do it is to use the .Clear method, and then re-load the list. It's the re-loading of the list that's sometimes a pain.

Anyone figured out how to clear the text without clearing the list?

Thanks,
Elroy

EDIT1: See, here's what I wind up doing, which is ugly. The cmd is just a "Clear" button. In this example, there are actually control arrays of cbo and cmd controls.

Private Sub cmd_Click(Index As Integer)
    Dim s() As String
    Dim i As Long
    '
    ReDim s(0 To cbo(Index).ListCount - 1)
    For i = 0 To cbo(Index).ListCount - 1
        s(i) = cbo(Index).list(i)
    Next i
    cbo(Index).Clear
    For i = 0 To UBound(s)
        cbo(Index).AddItem s(i)
    Next i
End Sub

[DataMiser]

Have you tried setting the listindex to -1 ?

[Elroy]

Well pfff. That was WAY too easy. I had envisioned an API call to the text portion of the ComboBox.

Thanks,
Elroy