Opening excel

R

Rusty

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make Combo Boxes not duplicate options 1
Combox In Form 5
Run time 9 error for some users but not everyone 10
Add to Combo Control from referenced worksheet object 0
Dynamic Naming of Form Button 3
Combobox will not show list 4
Use combobox value as sheetname to set sheet object 3
Optionbutton Not working 3

Top