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