I am not able get this problem straight out and need your help here; So I have a "sheet2" that has data with the header. I wanted to create header grid so the viewer can distinguish between header and data. Can we do that by making the code change or listbox properties to show header in grid format???
for reference, the code which reads the sheet
Private Sub UserForm_Click() BuildList End Sub Sub BuildList() Dim arr With Worksheets("Sheet2").Range("A:K").CurrentRegion arr = .Value End With With ListBox1 .ColumnCount = 5 ListBox1.List = arr End With End Sub
in this case, A1 to K1 are my headers and data starts from row A2 to K2. I want A1:K1 to show in header grid on listbox and rest data to be shown below...
thanks in advance!