Listbox headers

  • Thread starter Thread starter Robert Crandal
  • Start date Start date
R

Robert Crandal

For my listbox control, I set the value of "ColumnHeads" to True,
meaning that my listbox will contain headers for my columns. I
can now see the headers in my listbox, I just dont know how to
enter text into each header. how do i do that?

thank u

Robert
 
Those headers come from the row above the range you use for the .rowsource.

If your .rowsource is (say) A2:A10, then the column headings will be from row 1.
 
Ok, that works. If I set the .Rowsource, I can now see text in my
headers. However, if I now try to add a new item into the listbox
(using Listbox1.AddItem), I get an error message that says
"Permission Denied". What happened now??
 
You can use the rowsource or you can use additem. You can't use both.

And watch what happens when you use the column headers and additem.
 
Back
Top