combobox list resetting?
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.
--
HTH...
Jim Thomlinson
"QB" wrote:
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
|