title: combo box value from another workbook
body: <p>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.</p>
  
  <pre><code>ComboBox1.RowSource = "Sheet1!G1:G" &amp; Range("G" &amp; Rows.Count).End(xlUp).Row
  </code></pre>
  
  <p>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. </p>
  
  <p>Any idea what will the code be looks like? </p>