Solved: ListFillRange from another workbook

[ukdane]

How can I set the ListFillRange of a combobox, to list data from another workbook?

Sheets("mysheet").mycombobox.ListFillRange = WORKBOOKPATH WORKSHEET RANGE

What is the correct syntax?

[Bob Phillips]

Is it an ACtiveX cntrol?



Worksheets("Sheet1").OLEObjects("MyComboBox").ListFillRange = Workbooks("Stats 2009.xls").Worksheets("Forums").Range("A3:A14").Address(, , , True)

[ukdane]

No it isn't, but I found the problem, there was an error in the link that I copied.

With linked workbooks, when you start them up, it always shows a pop-up message box with Update | Don't Update | Help buttons. Is there a way to se this to default as Don't Update, and not show it when the worksheet starts?

[Bob Phillips]

If you open from VBA, you can use the UpdateLinks roperty

[Kenneth Hobs]

If it is not an activex control then it must be from the Forms toolbar?

Not sure how the link question relates to your subject line or first post. To solve that, you can do it manually or with a macro.

1. Edit > Links > Startup Prompt > Don't display the alert and don't update automatic links > OK > Close.
2. By macro, right click the Excel icon left of the File menu, View Code, and paste:
Private Sub Workbook_Activate()
ActiveWorkbook.UpdateLinks = xlUpdateLinksNever
End Sub