| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with rowsource
I have a form with a listbox. Before opening the form I create a public
array. I want to use the array as the rowsource for the listbox. MyForm.Listbox1.RowSource = MyArray does not work. How do I do that? TIA Glen |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help with rowsource
You don't use the rowsource
MyForm.Listbox1.List = MyArray -- Regards, Tom Ogilvy "GMet" wrote in message ... I have a form with a listbox. Before opening the form I create a public array. I want to use the array as the rowsource for the listbox. MyForm.Listbox1.RowSource = MyArray does not work. How do I do that? TIA Glen |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help with rowsource
What do I use?
"Tom Ogilvy" wrote in message ... You don't use the rowsource MyForm.Listbox1.List = MyArray -- Regards, Tom Ogilvy "GMet" wrote in message ... I have a form with a listbox. Before opening the form I create a public array. I want to use the array as the rowsource for the listbox. MyForm.Listbox1.RowSource = MyArray does not work. How do I do that? TIA Glen |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help with rowsource
Hi,
something like listbox1.List = myArray Regards, JY "GMet" wrote in message ... I have a form with a listbox. Before opening the form I create a public array. I want to use the array as the rowsource for the listbox. MyForm.Listbox1.RowSource = MyArray does not work. How do I do that? TIA Glen |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help with rowsource
I gave you the proper code.
-- Regards, Tom Ogilvy "GMet" wrote in message ... What do I use? "Tom Ogilvy" wrote in message ... You don't use the rowsource MyForm.Listbox1.List = MyArray -- Regards, Tom Ogilvy "GMet" wrote in message ... I have a form with a listbox. Before opening the form I create a public array. I want to use the array as the rowsource for the listbox. MyForm.Listbox1.RowSource = MyArray does not work. How do I do that? TIA Glen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combobox rowsource | Excel Programming | |||
| Using IF, Then with rowsource? | Excel Programming | |||
| RowSource Problem | Excel Programming | |||
| RowSource in ListBox | Excel Programming | |||
| listbox rowsource | Excel Programming | |||
Linear Mode
