I have a 2 column listbox populated from an array. The first column is a date and the second is a batch number. When the user double clicks on a value in the list box, I want to store the date AND the batch number to a variable. My problem is that displayvalue only gives me the first column. Is there a way to get the literal value of the second column (batch number) also.
DATE BATCH
01/01/01 A
01/01/01 B
01/01/01 C
01/02/01 A
01/02/01 B
I want to be able to select any ONE of the above by double clicking on it. Right now all I can return is the date so ALL of the above with the same date match the memvar.
For example if the second item in the list is double clicked, I want to store "01/01/01 B" not just "01/01/01" to the memvar.
Thanks in advance
Here's to alcohol...the cause of ... and solution to ... all of life's problems - - Homer J. Simpson