PDA

View Full Version : Solved: ListFillRange from another workbook



ukdane
05-06-2009, 01:44 AM
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
05-06-2009, 02:41 AM
Is it an ACtiveX cntrol?



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

ukdane
05-06-2009, 05:00 AM
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
05-06-2009, 05:25 AM
If you open from VBA, you can use the UpdateLinks roperty

Kenneth Hobs
05-06-2009, 05:28 AM
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