Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop-down list items are missing after reopen Workbook
Hi
Why is my list not saving? Because it has been created programmatically. If you want your list to keep its values without using VBA you will have to place them in your workbook. HTH Cordially Pascal "Compnerd" a écrit dans le message de news: ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop-down list items are missing after reopen Workbook
Hi
Hum... this needs a little more detail. Do you mean that the list of items is on another worksheet of the same workbook? Or the list is made from items from another Workbook? You may also consider building your list of items dynamically using an AutoOpen macro which means that it will automatically create your list when you open your workbook. Cordially Pascal "Compnerd" a écrit dans le message de news: ... I am using list to link to another worksheet, but I do not use sheet names in my list. can you give a example or some suggestion. "papou" wrote: Hi Why is my list not saving? Because it has been created programmatically. If you want your list to keep its values without using VBA you will have to place them in your workbook. HTH Cordially Pascal "Compnerd" a écrit dans le message de news: ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing Page Items Drop Downs | Excel Discussion (Misc queries) | |||
Creating a list of job numbers, missing out irrelevant items | Excel Worksheet Functions | |||
Duplication of items from a drop down list | Excel Discussion (Misc queries) | |||
drop down list item missing | Excel Programming | |||
missing items in sheet's activex list/combobox after resizing range | Excel Programming |