Thread: Reading data from a list box
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Aaron1978[_7_] Aaron1978[_7_] is offline
external usenet poster
  
Posts: 1
Default Reading data from a list box

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


--
Aaron1978
------------------------------------------------------------------------
Aaron1978's Profile: http://www.excelforum.com/member.php...o&userid=31201
View this thread: http://www.excelforum.com/showthread...hreadid=519362

Reply With QuoteReply With Quote