K
kankal
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.
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.