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