Hi,

Can anyone tell me how I can create an excel check box from a list in a
worksheet? I am trying to give users the option to print certain reports for
companies, but since company names can change frequently, I wanted to have
the source list in a spreadsheet so that you dont have to keep amending the
form.

Thanks in advance!!

You can check out this approach at John Walkenbach's site:

http://www.j-walk.com/ss/excel/tips/tip76.htm

Just use your list on the sheet where appropriate.

--
Regards,
Tom Ogilvy


"Jas" wrote:

> Hi,
>
> Can anyone tell me how I can create an excel check box from a list in a
> worksheet? I am trying to give users the option to print certain reports for
> companies, but since company names can change frequently, I wanted to have
> the source list in a spreadsheet so that you dont have to keep amending the
> form.
>
> Thanks in advance!!

Thanks Tom, that works perfectly.

"Tom Ogilvy" wrote:

> You can check out this approach at John Walkenbach's site:
>
> http://www.j-walk.com/ss/excel/tips/tip76.htm
>
> Just use your list on the sheet where appropriate.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Jas" wrote:
>
> > Hi,
> >
> > Can anyone tell me how I can create an excel check box from a list in a
> > worksheet? I am trying to give users the option to print certain reports for
> > companies, but since company names can change frequently, I wanted to have
> > the source list in a spreadsheet so that you dont have to keep amending the
> > form.
> >
> > Thanks in advance!!