I'm having a nasty problem with the ListFillRange property of a ComboBox.
I have a workbook with two sheets which loads another workbook containing two sheets of data when it is opened. One data sheet is supposed to be the data for the ComboBox in the first workbook.
The problem is that when the forms load clicking on the ComboBox shows empty data. If I go to the properties sheet of the ComboBox and cut (CTRL-X) the ListFillRange then immediately paste it back the ComboBox works fine. Go Figure!
Here is the code from my Open() in the first workbook:
Private Sub Workbook_Open()
Dim twbName As String
twbName = ThisWorkbook.Name
DisplayAlerts = False
' I can't make the line below work. I get a runtime 424 - object expected
' or something like that...
' Worksheets("Report").ComboBox1.ListFillRange = DRTables.xls!PartList
DisplayAlerts = True
Does anybody have a clue what's happening here?
Thanks for any help.