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?
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?
Is it an ACtiveX cntrol?
[vba]
Worksheets("Sheet1").OLEObjects("MyComboBox").ListFillRange = Workbooks("Stats 2009.xls").Worksheets("Forums").Range("A3:A14").Address(, , , True)
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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?
If you open from VBA, you can use the UpdateLinks roperty
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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:
[vba]Private Sub Workbook_Activate()
ActiveWorkbook.UpdateLinks = xlUpdateLinksNever
End Sub[/vba]