Headers in a list box only work in Excel, and if you set the RowSource of the list box to a range of cells. Headers don't work in combination with AddItem. You could fill range A1:C1 with headers, and A2:C5 with data, then use ListBox1.RowSource = "Sheet1!A2:C5" The header row is NOT included in the RowSource, but it should be located directly above the RowSource. |
