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
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