LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Drop-down list items are missing after reopen Workbook

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.

Why is my list not saving?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Missing Page Items Drop Downs Andrew Excel Discussion (Misc queries) 0 September 30th 08 06:50 AM
Creating a list of job numbers, missing out irrelevant items DDawson Excel Worksheet Functions 9 December 18th 07 01:42 AM
Duplication of items from a drop down list LTaylor Excel Discussion (Misc queries) 0 December 5th 07 04:06 PM
drop down list item missing Compnerd Excel Programming 0 March 7th 05 02:33 AM
missing items in sheet's activex list/combobox after resizing range Tim Zych[_2_] Excel Programming 1 August 11th 03 10:48 PM


All times are GMT +1. The time now is 06:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"