View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kankal kankal is offline
external usenet poster
 
Posts: 1
Default 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