excel vba - userform list source in other workbook

  • Thread starter Thread starter skip
  • Start date Start date
S

skip

i need a userform listbox with a rowsource that can view a list i
another worksheet or workbook.

also a dropdown list on the userform to change the rowsource and view
different list on a different workbook

i am getting close but not close enough to make it wor
 
Assuming the workbook is open.

'[workbookname.xls]Sheet1'!A1:B200
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show userform from another workbook 2
Worksheet appears briefly before UserForm opens 4
closing another file by code causes failure to run workbook activate event 2
Combo box source from other workbook 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
how to reshow userform after following a link 1
Userform to Select what worksheets to print 1
Hide Userform when viewing a different workbook 3

Back
Top