Populating Comboboxes

  • Thread starter Thread starter nannon8
  • Start date Start date
N

nannon8

I have an excel template which has some userforms in it. On one of the
userforms are 9 combo boxes, all of which need to display the same data
from another workbook. Problem is I don't have a clue how to achieve
this, can anyone help?
 
For each combobox, set the RowSource property to that range, including the
sheet name. BTW, I assumed that when you said workbook, you meant worksheet.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Hi, the data is in a different file. The problem that I have is
referencing the Rowsource to the second workbook.
 

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

Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
use ComboBox value to select range and then use selected range tocreate a chart 3
ComboBox Dropdown not under control 1
how to reshow userform after following a link 1
Duplicate items in ComboBox 1
Worksheet appears briefly before UserForm opens 4
Using VLookup on user form (VBA) 6
Populate A Userform ComboBox 2

Back
Top