| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you find the list option in excel on office xp | Excel Worksheet Functions | |||
| calender as a drop down list option in excel | Excel Discussion (Misc queries) | |||
| .txt file to mail list (excel best option) | New Users to Excel | |||
| Does Excel 2002 have a List>Create List option under Data? | Excel Discussion (Misc queries) | |||
| How do I enter a working check box option in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
