How to make Combo Boxes not duplicate options

G

Guest

If you pick the Atlanta option(in the VBA code below) when you go back and
re-open the combo box it relists all the options atleast three times or more.
Is there any way after you make a selection on a combo box to keep the
option from duplicating and only show the list of options once?


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

Dave Peterson

Why would you add the items to the combobox in the _change event?

If this is in a userform, maybe you could use userform_initialize to populate
that combobox.
 

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

ComboBox Problems 1
combo box value 1
Combo Boxes 2
Using combo box to change color of tabs (xl 2003) 3
Combo Box w/ Links Revert to Default Text 3
How to display data in Combobox with no dups 2
How do I populate my combobox - I know...it's been asked. 5
Search for a Specific Worksheet Macro or Function? 1

Top