| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto fill Certain data from Sheet 1 to Sheet 2 | Excel Worksheet Functions | |||
| fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
| Fill ComboBox with Filtered Data | Excel Programming | |||
| Combobox data accidentally copied on different sheet | Excel Programming | |||
| pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
Linear Mode
