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

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

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

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

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