Check/Option box from Excel list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jas - 21 Jan 2008 10:43 GMT

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!!

Reply to this Message

Tom Ogilvy - 21 Jan 2008 11:22 GMT

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.

Signature

Regards,
Tom Ogilvy

> Hi,
>
[quoted text clipped - 5 lines]
>
> Thanks in advance!!

Reply to this Message

Jas - 21 Jan 2008 11:33 GMT

Thanks Tom, that works perfectly.

> You can check out this approach at John Walkenbach's site:
>
[quoted text clipped - 11 lines]
> >
> > Thanks in advance!!

Reply to this Message