| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hard code date in header | Excel Programming | |||
| refernce header text in code | Excel Programming | |||
| Hard return in textbox for header text | Excel Programming | |||
| ListBox with header row, delete row, protect header row | Excel Programming | |||
| Having a hard time with listbox | Excel Programming | |||
Linear Mode
