View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zack Barresse[_3_] Zack Barresse[_3_] is offline
external usenet poster
 
Posts: 101
Default Please Explain Two Lines of Code

Hello there,

This looks like part of a userform code for a listbox. Basically it's
adding an item to the list with the first line, which is defined by the
range of Source, whatever that is, with a variable row but always in the
second column (of said range). The second line is changing part of the list
with the third column of the same variable row of the Source range.

Other than that it's very hard to tell without seeing 1) the rest of your
code, or 2) knowing how your workbook is structured.

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.


"ca1358" wrote in message
...
Could you please explain the two lines of code?


Private Source as Range

.AddItem Source.Cells(index, 2)
.List(.ListCount) -1, a) = Source.cells(index, 3)


Thank you!
--
ca1358