combobox list resetting?

  • Thread starter Thread starter QB
  • Start date Start date
Q

QB

I have a workbook with several cbos. They are populate when the user clicks
a button (the data comes from another app). I use code like below to
populate them

Sheets("Contract variables").cboServices1.AddItem (Pop_cboServices(i))

This all works fine. The problem I seem to be having is that when I close
the workbook (after saving first) and then reopen it, all my cbos are empty
once again and one must reload the values (which is a slow process). What am
I missing?

Thank you for the help,

QB
 
ActiveX combo boxes do not store values. They must be populated at run time.
If your values come from another app perhaps bring them into a dedicated
worksheet in this workbook and populate from there. The values in the
worksheet will be stored.
 
Now that's what I call a serious pain in the ....!

Thank you for the info, and more importantly, the workaround.

QB
 

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

Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Populate combobox 6
Worksheet Names (Revised) 2
Populate 2nd combo box based on value selected in first combo box? 2
Populating combox with worksheet names 2
ComboBox Drop Down List 5
lookup 3
Merge Multiple workbook sheets into one workbook 0

Back
Top