Listbox Control Source Question

[eddiev1972]

Can the controlsource property of a listbox refer to a different workbook from where the macro resides? If so, does that workbook need to be open?

I am receiving a "Could not set the controlsource property" error when trying to do so. It is possible I just have the syntax wrong.

I am setting the controlsource property to variable called "tempstring"

TempString displays as:

“W:\Data\[1035_CompData.xls]Sheet1’!a2:f14”

(The quotes generate as part of the string)

ListBox1.ControlSource = TempString

Thanks for any assistance!

 

[Juan Pablo González]

The workbook needs to be open, and then, don't include the path of the workbook.

 

[eddiev1972]

That worked.

Thanks for your help!

 

[Trevor G]

Your workbook would need to be open and I would set the RowSource, you also had an quote mark in your line not needed remove red marks

“W:\Data\[1035_CompData.xls]Sheet1’!a2:f14”

Master!A2:A5

 

[eddiev1972]

Thank you for the additional information.

I actually did mean Row Source and I appreciate the help with the quotation mark!