Greetings,

I've been trying for awhile to have a options appear in a ComboBox in Microsoft Excel by using the following code:

Private Sub Document_Open()

ComboBox1.Clear
ComboBox1.AddItem "Jan"
ComboBox1.AddItem "Feb"
ComboBox1.AddItem "Mar"
ComboBox1.AddItem "April"
ComboBox1.AddItem "May"
ComboBox1.AddItem "June"
ComboBox1.AddItem "July"
ComboBox1.AddItem "August"
ComboBox1.AddItem "September"
ComboBox1.AddItem "October"
ComboBox1.AddItem "November"
ComboBox1.AddItem "December"

End Sub

This works in Microsoft Word but not in Excel. When opening the document, "Jan" will appear in the Combo Box but nothing else will appear after clicking on the down arrow. Could anyone tell me what I am doing wrong?

Also, I would ultimately like to have this option pop up asking to pick a month when the worksheet first loads (Prompt the user for the month and then have it fetch data). Is this possible?

Thanks!
Dan