Runtime Error -2147417848(80010108)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top