Combo box values

[spg2112]

Hi all,

I have a couple of combo boxes that for some reason lose their values every now and then. I go to select a value and the pull-down is blank. I have to save and close the file to get them to appear again. Any ideas?

Steve

 

[stevebausch]

This happens when the code crashes? Or just out of the blue?

Some of my variables will loose assignment when I stop the code, the code errors out, etc.

Where are the values being assigned? I suspect the assignment is being done in Workbook_Open, or the assignment can be traced back to _Open.

I understand if the variables must be assigned early on. You may just need to have the reassignment code (in my case, GetSetting is involved) be called again in Userform_Initialize.

 

[spg2112]

Hello,

It happens just out of the blue. They're not assigned variables at all. I just used the "List Fill Range" option under properties, then referenced a range on the sheet.

Steve

 

[Joe Was]

This happens when you have too little memory or you used ranges that total to more than: 56 colors, 4,000 cell styles, 32 field types or 32 cells who's content changes.

If none of the above seems to apply then a application code problem may be forcing the change?
Does it only happen on one application or on more than one? JSW