What is the syntax to read cells to a list box?

<listbox name>.AddItem Sheets("<sheet name>").Cells(<row>, <column num>).Value
#example
lineDisplay = Sheets("Foods").Cells(1, 1).Value & Chr(9) & Sheets("Foods").Cells(1, 2).Value
lstFoods.AddItem lineDisplay 

 

 

Advertisements