Check/Option box from Excel list
 

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

Check/Option box from Excel list
 

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

Check/Option box from Excel list
 

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