From: Robert Crandal on
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??



"Dave Peterson" <petersod(a)verizonXSPAM.net> wrote in message
news:4B9250CC.10756698(a)verizonXSPAM.net...
> 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.
>
>

From: Dave Peterson on
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.

Robert Crandal wrote:
>
> 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??
>
> "Dave Peterson" <petersod(a)verizonXSPAM.net> wrote in message
> news:4B9250CC.10756698(a)verizonXSPAM.net...
> > 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.
> >
> >

--

Dave Peterson