I have a form with several list boxex. The form feeds an Excel spread sheet. I need to move thed data from the list box to the spread sheet. Some times it works, and some times it doesn't. I have varified that the list indexes are correct, and have even forced them just before accessing the value, what is returned is either "" (null) or the correct value, I have also tried setting the selected value to true using the associated list index. the results are the same. Is the a method that i can use to match the value in a list box to a value and then return the either changed or unchanged value from the list box. I am using a value limited for loop to find the matching index and the reseting the index.
Thanks for any help you can off, this is driving me crazy.. I really need some sleep