Populate one combo box from results of another combo box

Can't seem to figure out what's going on here. I have the first combo box which I can select the day and the second combo box will display the month.

Everything works fine until I select a day in which there is only one month and then I get the following error.

Error 381 (Could not set the List property Invalid property array index)

Is this also the best way to populate the second combo box off of the results from the first?

I ran a breakpoint and cbomonth shows null.

Please Login or Register  to view this content.

The List property expects an array, and one cell value is not an array. Check the source range count: if it's 1, then use additem (clear the list first); otherwise use List.

No worries. Please don't forget to mark the thread 'Solved'.