Please Explain Two Lines of Code
 

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

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