Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combobox query
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 |
#2
|
|||
|
|||
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) "Nigel" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
Excel2000 ODBC query oddity | Excel Discussion (Misc queries) | |||
Query of External Data | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Tricky ComboBox / Filter query | Excel Discussion (Misc queries) |