Cmdbutton, cbobox and Runtime Error 381:Invalid Property Array Index

[Castaway1958]

Hi, I have an Excel Spreadsheet in Excel 2003 with 2 command buttons and 1 hidden combo box. Command Button 1 when clicked should populate and unhide the combo box with a list of Countries. When command button 2 is clicked it should clear the combo box and then populate it with a list of cities. These Countries and cities are listed on another worksheet in the workbook. My problem is that when I click either button I get the Run Time Error 381: Could not get the Column Property. Invalid property array index. When debugged the line that highlights is in my cbo_Change(). When I mouse over the line that says (0, cbomix.ListIndex) it says ListIndex = -1. I know this means that no element was selected in the combo box but I can not get the box to populate without getting this error. Thank you for any insight.

 

[ClulessChris]

Could you post the code that's throwing the error?

Never knock on Death's door: ring the bell and run away! Death really hates that!