Fill combobox from data in different sheet
 

I have placed a combobox straight onto say Sheet1 from the control toolbox
and have a list of items on say sheet2. How do i fill the combobox with the
list of items shown on sheet2. By manually typing the cell range in the
combobox property ListFillRange it does not work, they disappear!

Any help will be gratefully received
--
with kind regards

Spike

Fill combobox from data in different sheet
 

How did you type in that value?

I used
Sheet2!A1:A10
or
'Sheet 2'!a1:a10

And it worked ok.



Spike wrote:

I have placed a combobox straight onto say Sheet1 from the control toolbox
and have a list of items on say sheet2. How do i fill the combobox with the
list of items shown on sheet2. By manually typing the cell range in the
combobox property ListFillRange it does not work, they disappear!

Any help will be gratefully received
--
with kind regards

Spike

--

Dave Peterson

Fill combobox from data in different sheet
 

Thank you so much i have been staring at that when you replied to someone
else previously but assumed incorrectly that i needed to put in Sheets(blah
blah etc) sorry obvious like most of these things!!! VEry much appreciate
your time
--
with kind regards

Spike


"Dave Peterson" wrote:

How did you type in that value?

I used
Sheet2!A1:A10
or
'Sheet 2'!a1:a10

And it worked ok.



Spike wrote:

I have placed a combobox straight onto say Sheet1 from the control toolbox
and have a list of items on say sheet2. How do i fill the combobox with the
list of items shown on sheet2. By manually typing the cell range in the
combobox property ListFillRange it does not work, they disappear!

Any help will be gratefully received
--
with kind regards

Spike

--

Dave Peterson