Hi,
I would like to put a header into my ListBox but since the values inside the
ListBox are calculated inside VBA, what is the best way to proceed? I tried
to put ColumnHead = True but rowsource needs to be inside excel. Is there a
way to add value from rowsource inside VBA instead like?
Dim aHeaders as Variant
aHeaders = Array("Head1", "Head2", ...)
Me.ListBox1.RowSource = aHeaders
Actally, value are added as:
For i = 0 To 10
Me.ListBox1.AddItem fTableValue(i+1,1)
Me.ListBox1.List(i, 1) = fTableValue(i+1,2)
Next i
Maybe i = 0 could be the header.. but I cannot put these cells in gray...
Thanks a lot!
--
Alex St-Pierre