basic listbox question (reading from a cell)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

veggiesaregood@gmail.com - 28 Mar 2005 18:28 GMT

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!

Reply to this Message

veggiesaregood@gmail.com - 28 Mar 2005 20:28 GMT

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

Reply to this Message

J Laroche - 28 Mar 2005 23:22 GMT

veggiesaregood@gmail.com wrote on 2005/03/28 14:28:

> 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

Reply to this Message

Mac Forum / Applications / Excel / March 2005

basic listbox question (reading from a cell)