combobox list resetting?
 

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

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

combobox list resetting?
 

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

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

QB





"Jim Thomlinson" wrote:

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