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

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