View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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