Hi all,

Excel 2003
I have a combo box named cboCategory.
After selecting an item from the list, that item remains "active" and can't
be selected next time.
I've tried adding cboCategory.ListIndex = -1 but this causes an error, as
follows.

Run-time Error 381
Could not get the Column property. Invalid property array index

The code used is as follows:

Private Sub CboCategory_Change()
Application.EnableEvents = False
ActiveCell = CboCategory.Column(1)
ActiveCell.Offset(0, -1) = CboCategory.Column(0)
ActiveCell.Select
Application.EnableEvents = True
End Sub

Any pointers ?
Thanks and regards,
Don