After Workbook closes all my combo boxes do not retain dropdown list.

C

cwsax

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
 

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

Macro VBA coding, Copying content from one workbook to a new one 0
Combo Boxes - What to do first 3
Excel prompts for VBApassword after saving workbook under new name and exiting excel 0
Synchronize Combo Boxes? 2
Having trouble with combo boxes. 11
How to Store Passwords To Multiple Sheets and To Retain thatPasswords When the Workbook IS closed 1
VB Combobox field problem in Excel 2000 3
Populate Combo Box 6

Top