Hi Experts,
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
Code
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
Display More
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!