I have created a combo box in VB that works fine using the following code...

Private Sub ComboBox1_Change()
ComboBox1.List = Array("Red", "Yellow", "Blue","")
End Sub

The problem that I am having is that when I exit out of excel and then
reopen the workbook the combo box no longer works. I have to go back into VB
and click RUN SUB/USER FORM to get it to work again. I have never used VB so
I figure I must have something wrong with my code or am overlooking something
simple.

Any suggestions would be appreciated...Thanks