Combo Box List

G

Guest

This is the code I have for a combo box,

Private Sub ComboBox1_GotFocus()

With ComboBox1
.Text = "Select Dimension"
.AddItem "Weight"
.AddItem "Flange Thickness"
.AddItem "OAL"
.AddItem "Body Length"
.AddItem "Counter Bore"
End With

End Sub

For some reason, the drop down menu lists these five options seven times
over. I'm new to VBA, why is this.
 
C

Chip Pearson

You probably want to Clear the combobox before adding items to
it.

.Clear


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
G

Guest

Chip! Great to see you! I LOVE your website and recommend it often to my
clients! Thanks for just being you!

Cindee
 

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

Add items to a combo box and make them available after closing the sheet 1
list box remove item by combobox 4
Populate 2nd combo box based on value selected in first combo box? 2
VBA Combo Box 3
How to fill a combo box with choice from another combo box 7
Clear entries on Combo box 1
open worksheet on first unlocked cell 5
Combo Boxes 2

Top