drop down list item missing

C

Compnerd

I am using Control Toolbox, choose the ComboBox, Double click into VB screen,
type the following code:
Private Sub Form_Load()
Combo1.AddItem "Chardonnay"
Combo1.AddItem "Fum Blanc"
Combo1.AddItem "Gewrztraminer"
Combo1.AddItem "Zinfandel"
End Sub
Then click on run sub/user form, then exit out, it popluate the list, save
the Workbook and close it. Then open the same Workbook the the Combobox has
the last item click, but the rest of my list is not showing. I can go into
the VB and find it my list there, if I click on run it will populate the list
again.

What am I missing or doing wrong.
 

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

Drop-down list items are missing after reopen Workbook 3
Losing Items in Forms.ComboBox Problem 2
Show full Combo List at once 4
Need help in creating dynamic drop down list in userform 2
VB Combobox field problem in Excel 2000 3
Put items in combobox using VBA and toolbox 3
Use match function to add different item in Combobox 2
Excel 2007 ListBox missing last item 3

Top