Listbox headers

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
 
D

Dave Peterson

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.
 
R

Robert Crandal

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??
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top