Hard code Listbox Header Text
 

I have a listbox with 5 Columns that has a header row. Is there a way to
hard code the text that is in the header in the userform Intialize Event? I
know you can do it with RowSource, but I wanted a way to do it with VBA.

Thanks in Advance!
--
Cheers,
Ryan

Hard code Listbox Header Text
 

You could assign the rowsource in code, but that's probably not what you meant.

You have to use the rowsource to get the headings.

Ryan H wrote:

I have a listbox with 5 Columns that has a header row. Is there a way to
hard code the text that is in the header in the userform Intialize Event? I
know you can do it with RowSource, but I wanted a way to do it with VBA.

Thanks in Advance!
--
Cheers,
Ryan

--

Dave Peterson

Hard code Listbox Header Text
 

Another option may be to put labels over the listbox????

Dave Peterson wrote:

You could assign the rowsource in code, but that's probably not what you meant.

You have to use the rowsource to get the headings.

Ryan H wrote:

I have a listbox with 5 Columns that has a header row. Is there a way to
hard code the text that is in the header in the userform Intialize Event? I
know you can do it with RowSource, but I wanted a way to do it with VBA.

Thanks in Advance!
--
Cheers,
Ryan

--

Dave Peterson

--

Dave Peterson