I'm having trouble with having the combo boxes coming up when I first open
excel. I can change the text to column to 2 and it works fine but the value
you select will not show up. I can set the value at -1 and it works fine
except when you first open excel the drop down doesnt' come up unless you
clear it. Then after that point it works fine. Is there anyway to make or
force the combo box to alway work when you open excel clearing out the combo
box? Here is the basic code I used

Private Sub ComboBox1_Change()
ComboBox1.AddItem "Atlanta"
ComboBox1.AddItem "Washington DC"
Sheets("Questionaire").Range("N7") = ComboBox1.Value