combobox list resetting?

[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

 

[Jim Thomlinson]

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.

 

[QB]

Now that's what I call a serious pain in the ....!

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

QB