Check/Option box from Excel list

[Jas]

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

 

[Tom Ogilvy]

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.

 

[Jas]

Thanks Tom, that works perfectly.

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.