Combobox Additem crashes

[st_peters]

Hi everyone,

I have been experiencing random Excel crashes when I use the function "ComboBox.AddItem ArrayDirector(i, 1)". The code works perfectly 8 out of 10 times, but every once in a while Excel crashes at the same .AddItem function.

This problem only happens when I start my code/application, when the comboboxes are being initialized and loaded. After that, my function is called several times without any crashes.


Sub Box_Directeurs()

Dim num As Integer
Dim i As Integer
Application.EnableEvents = False

For i = 1 To 4
DirectorBox.AddItem ArrDirector(i, 1)
Next i

Application.EnableEvents = True
End Sub


Also, I've been having the same crashes when I change the caption of a label during the initialization (lbl.caption = currentWeek).

Any help would be greatly appreciated.

Thanks,

Peter

 

[Norie]

Peter

Where/how are you populating the array ArrDirector?

 

[st_peters]

Hi,

Thanks for the reply.

Just before I load the combobox, I have a SUB that populates the ArrDirector from data located in an excel sheet.

For your information, I also tried loading the combobox with a string constant and I get the same result: DirectorBox.AddItem "John Smith".

So I dont believe that the problem is with the array.

Thanks again.

 

[Norie]

Do you get any error message(s)?

 

[st_peters]

Nothing at all. Excel just crashes.

I don't get error messages because it works 90% percent of the time. So i know the code is good. It seems that sometimes it crashes for reasons i don't know (timing issues,...).

 

[Norie]

Could you upload a sampe workbook, without sensitive data, to a filesharing site like Box.net?