Problems with setting values in a listbox
 

Hi,
I'm two listboxes each one has 2 columns and i hv written code that
transfers values from one listbox to another. however, i can't get to
set the value of a single listitem. the only option it allows me is to
use a 2-d array and set it to the list property.
as i saw in help a statement like
listbox1.list(0,0) = "somevalue"
should be possible, even if i try the above statement it gives me an
error in exactly that statement:
run time error 381: could not get the list property. Invalid
property array index.

a listbox index starts with zero, so it shouldn't be a problem, so i
don't understand where am i wrong or is this a bug with the product.
I'm using excel 2000 and VBA version is 6.3

I would appreciate any help.
Thanks in advance.


--
kankal
------------------------------------------------------------------------
kankal's Profile: http://www.excelforum.com/member.php...o&userid=16870
View this thread: http://www.excelforum.com/showthread...hreadid=320526

Problems with setting values in a listbox
 

This worked for me

Me.ListBox1.List(1) = "Lynne"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kankal" wrote in message
...

Hi,
I'm two listboxes each one has 2 columns and i hv written code that
transfers values from one listbox to another. however, i can't get to
set the value of a single listitem. the only option it allows me is to
use a 2-d array and set it to the list property.
as i saw in help a statement like
listbox1.list(0,0) = "somevalue"
should be possible, even if i try the above statement it gives me an
error in exactly that statement:
run time error 381: could not get the list property. Invalid
property array index.

a listbox index starts with zero, so it shouldn't be a problem, so i
don't understand where am i wrong or is this a bug with the product.
I'm using excel 2000 and VBA version is 6.3

I would appreciate any help.
Thanks in advance.


--
kankal
------------------------------------------------------------------------
kankal's Profile:
http://www.excelforum.com/member.php...o&userid=16870
View this thread: http://www.excelforum.com/showthread...hreadid=320526