Fill combobox from data in different sheet

G

Guest

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
 
D

Dave Peterson

How did you type in that value?

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

And it worked ok.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combobox 2
Add Item To ActiveX ComboBox 17
populate combobox from worksheet in different workbook 3
How to Set VB ComboBox ListFillRange to a Defined Range in an external workbook 1
Combobox 3
combobox fill problem 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
ListFillRange 4

Top