Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error 13 when setting worksheet listbox | Excel Discussion (Misc queries) | |||
Setting Listbox Size VBA | Excel Worksheet Functions | |||
Setting and filter Listbox data | Excel Discussion (Misc queries) | |||
problems resetting backcolor in listbox | Excel Programming | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |