Prev: Move macro to Personal.xls
Next: refreshing combo box in form?
From: Robert Crandal on 6 Mar 2010 14:48
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 6 Mar 2010 15:01
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
 | 
Pages: 1
Prev: Move macro to Personal.xls
Next: refreshing combo box in form?