Combobox query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
on a combobox added by the control box, how can i link the data from a
separate sheet to the combobox? it works with th e data on the same sheet but
i cannot seem to get it from a separate sheet. is it something to do with
ListFillRange?
If so, how do i format this to accept my data from another sheet?

Also, can it get data from another workbook?

Regards,

Nigel
 
Nigel,

Just preced the range by the sheet name as you would in a worksheet formula,

'sheet name'!A1:A20

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

comboboxes 1
Control ToolBox ComboBox 1
Worksheet Combobox 1
Is this possible 5
ComboxBox with Dynamically Defined Source, and LinkedCell error 1
ActiveX Queries - combobox, Source data in another workbook. 1
populate combobox from worksheet in different workbook 3
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0

Back
Top