combo box value from another workbook

[abadilala]

Hi, I am creating excel macro for combo box in user form. I have succeed to create in single workbook.
Here is my code in current workbook.

ComboBox1.RowSource = "Sheet1!G1:G" & Range("G" & Rows.Count).End(xlUp).Row

What I want to do now is, I want to get the value for my combo box from another workbook, lets say Project.xlsx in range column G.

Any idea what will the code be looks like?

 

[Jaafar Tribak]

Try this :

ComboBox1.RowSource = "[[COLOR=#333333]Project.xlsx[/COLOR]]" & "Sheet1!G1:G" & Range("G" & Rows.Count).End(xlUp).Row