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