Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
After Workbook closes all my combo boxes do not retain dropdown list.
Hi all,
I wrote a module that populates all Combo Boxes (ActiveX Controls) when a check box is clicked and whenever I save and exit the workbook the combo boxes empty. Is there a way to make the value of the Combo Boxes to stick around after the workbook closes? Below is an example of the code for one of my Combo Boxes. Any hints would be greatly appreciated. Excel 2000. Public Sub Specify_Network_Speed() If Sheets("Input").cboNetworkSpeed.ListIndex < 0 Then Sheets("Input").cboNetworkSpeed.AddItem "" Sheets("Input").cboNetworkSpeed.AddItem "10 Mbps" Sheets("Input").cboNetworkSpeed.AddItem "100 Mbps" Sheets ("Input").cboNetworkSpeed.AddItem "Other/mixed" 'Use a drop down list Sheets("Input").cboNetworkSpeed.Style = fmStyleDropDownList 'Combo box values are ListIndex values Sheets("Input").cboNetworkSpeed.BoundColumn = 0 'Set Combo Box first entry Sheets("Input").cboNetworkSpeed.ListIndex = 0 End If End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dependant Dropdown lists using Combo Boxes | Excel Discussion (Misc queries) | |||
Prevent List Box Reference from Changing when workbook closes? | Excel Discussion (Misc queries) | |||
combo box dropdown list | Excel Worksheet Functions | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel |