Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Listbox Populate Problem
This a 2 part question, both involving filling a listbox on a worksheet.
1.) How do I have the listbox have multple columns and have the data source be B2:D12? 2.) How do I have a worksheet listbox populate from an un-opened workbook? Everytime I enter for the ListFillRange =B2:D12 and that doesnt work. Thank you in advance for anyone that helps. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Listbox Populate Problem
set the columncount property to 4
as I recall, you have to have the source workbook open. What you could try is putting linking formulas in either a hidden sheet or another area of your sheet and then use that as the rowsource. sheetHidden!B2:D12 in the rowsource property. On the worksheet named sheetHidden (for example), put in formula in B2 like =C:\Myfolder[Myfiler]sheet1!B2 then drag fill down and across to D12 (obviously the linking formlas don't have to be in the same cells locations as the source data - that was just for illustration). -- Regards, Tom Ogilvy "Benz" wrote: This a 2 part question, both involving filling a listbox on a worksheet. 1.) How do I have the listbox have multple columns and have the data source be B2:D12? 2.) How do I have a worksheet listbox populate from an un-opened workbook? Everytime I enter for the ListFillRange =B2:D12 and that doesnt work. Thank you in advance for anyone that helps. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Listbox Populate Problem
1) in the properties for the list box, the column count should be 3 and the
listfillrange should be B2:D12 2) make sure the column count is 3 hope this helps, -Chad "Benz" wrote: This a 2 part question, both involving filling a listbox on a worksheet. 1.) How do I have the listbox have multple columns and have the data source be B2:D12? 2.) How do I have a worksheet listbox populate from an un-opened workbook? Everytime I enter for the ListFillRange =B2:D12 and that doesnt work. Thank you in advance for anyone that helps. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Listbox Populate Problem
That was very helpful, thank you Tom & Chad.
Have a good weekend! "Tom Ogilvy" wrote: set the columncount property to 4 as I recall, you have to have the source workbook open. What you could try is putting linking formulas in either a hidden sheet or another area of your sheet and then use that as the rowsource. sheetHidden!B2:D12 in the rowsource property. On the worksheet named sheetHidden (for example), put in formula in B2 like =C:\Myfolder[Myfiler]sheet1!B2 then drag fill down and across to D12 (obviously the linking formlas don't have to be in the same cells locations as the source data - that was just for illustration). -- Regards, Tom Ogilvy "Benz" wrote: This a 2 part question, both involving filling a listbox on a worksheet. 1.) How do I have the listbox have multple columns and have the data source be B2:D12? 2.) How do I have a worksheet listbox populate from an un-opened workbook? Everytime I enter for the ListFillRange =B2:D12 and that doesnt work. Thank you in advance for anyone that helps. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Listbox Populate Problem
OK, set the columncount property to 3 - but you get the idea.
-- Regards, Tom Ogilvy "Tom Ogilvy" wrote: set the columncount property to 4 as I recall, you have to have the source workbook open. What you could try is putting linking formulas in either a hidden sheet or another area of your sheet and then use that as the rowsource. sheetHidden!B2:D12 in the rowsource property. On the worksheet named sheetHidden (for example), put in formula in B2 like =C:\Myfolder[Myfiler]sheet1!B2 then drag fill down and across to D12 (obviously the linking formlas don't have to be in the same cells locations as the source data - that was just for illustration). -- Regards, Tom Ogilvy "Benz" wrote: This a 2 part question, both involving filling a listbox on a worksheet. 1.) How do I have the listbox have multple columns and have the data source be B2:D12? 2.) How do I have a worksheet listbox populate from an un-opened workbook? Everytime I enter for the ListFillRange =B2:D12 and that doesnt work. Thank you in advance for anyone that helps. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Listbox Populate Problem
OK, that was stephanieH that was using rowsource. Everywhere I said
rowsource, substitute listfillrange. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote: set the columncount property to 4 as I recall, you have to have the source workbook open. What you could try is putting linking formulas in either a hidden sheet or another area of your sheet and then use that as the rowsource. sheetHidden!B2:D12 in the rowsource property. On the worksheet named sheetHidden (for example), put in formula in B2 like =C:\Myfolder[Myfiler]sheet1!B2 then drag fill down and across to D12 (obviously the linking formlas don't have to be in the same cells locations as the source data - that was just for illustration). -- Regards, Tom Ogilvy "Benz" wrote: This a 2 part question, both involving filling a listbox on a worksheet. 1.) How do I have the listbox have multple columns and have the data source be B2:D12? 2.) How do I have a worksheet listbox populate from an un-opened workbook? Everytime I enter for the ListFillRange =B2:D12 and that doesnt work. Thank you in advance for anyone that helps. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array to Populate ListBox Problem | Excel Discussion (Misc queries) | |||
populate listbox? | Excel Programming | |||
Using a VBA listbox to populate a worksheet | Excel Programming | |||
populate listbox | Excel Programming | |||
ListBox Populate | Excel Programming |