Reading data from a list box
Aaron,
How many columns are there in your listbox?
".Column(2," is actually column 3.
Take another look at my last message.
Jim Cone
"Aaron1978" wrote in message...
Thanks again, however I'm still getting an error. I've used two lines of
code to write the values contained in the list box to the spread sheet:
Cells(9, 3).Value = lstGradeAndSMYS.Column(1,
lstGradeAndSMYS.ListIndex)
Cells(8, 3).Value = lstGradeAndSMYS.Column(2,
lstGradeAndSMYS.ListIndex)
Excel if happy with the first line of code but it doesn't like the
second. I get an error saying "Runtime Error....Could not get the
column property. Invalid Argument".
Any ideas what is going wrng here?
Best Regards,
Aaron
|