Runtime Error -2147417848(80010108)

  • Thread starter Thread starter Heinrich Kotze
  • Start date Start date
H

Heinrich Kotze

Maybe this something quite easy, so I hope somebody can
help me.

When I open an excel file and enable macros the following
error pops up:

"Runtime Error '-2147417848(80010108)':
Method 'ListfillRange' of object 'IMdcCombo' failed.

The code it jumps into is:

Private Sub ComboBox1_Change()

FillComboBox1

Combo1 = ComboBox1.Value

End Sub

Private Sub FillComboBox1()

ComboBox1.ListFillRange = "WholeSalers"

End Sub

Bets of all is. If I debug and step through the code it
works and then excel bombs out and sends an error report.

Can anybody please help me on this?

Thanks in advance
Heinrich
 
Back
Top