what do i have to do to get a combobox in file (test) to access data in file
(data)

ie what code do i hnave to put in the listfillrange in the combobox properties

I think the easiest way to accomplish that will be linking the "data" range
(from the DATA WorkBook) with an equal size range in the WoekBook TEST and
use that range to be the listfillrange source.
Micky


uk" wrote:

what do i have to do to get a combobox in file (test) to access data in file
(data)

ie what code do i hnave to put in the listfillrange in the combobox properties