basic listbox question (reading from a cell)

[veggiesaregood]

Hi,

I am fairly new to VB and I had a question about listboxes. If I have
a multi-row, multi-coolumn listbox and I want to read the value out of
a specific cell of that listbox, how can I do that. I have tried
reading ListBoxName(j,k).text into a string and I have tried reading
ListBoxName(j,k).Cell into a string but both of these are incorrect.

Please let me know if you know the correct way to do this.

Thanks!

 

[veggiesaregood]

I got it to work using the column method of listboxes.
Thanks.

 

[J Laroche]

I got it to work using the column method of listboxes.
Thanks.

You almost had it before: ListBoxName.List(j,k).

In the Visual Basic editor, open the objects browser. In the Classes pane,
scroll down to and click on ListBox. The right pane will show Members of
"ListBox". Control-click on any member and select Help to see what it does.

JL
Mac OS X 10.3.8, Office v.X 10.1.6