Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting tick/untick boxes in excel 2003
Greetings,
Sorry if this is a stupid question. I have a spreadsheet and i want to enter 3 rows of boxes that i can simply click on to tick or untick them. Its for a questionnaire so answers will vary from one person to another so i would just like to click on the boxes to enter the tick for either a yes, no, or not applicable answer. I hope this makes sense, i already have the spreadsheet i want with this tick/untick facility but its locked so i cant amend it to meet my needs :o( hope someone can help otherwise im gonna have to start drinking this lunchtime!!! If someone could lay out a simple step by step process i would be most grateful! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting tick/untick boxes in excel 2003
First of all, you would not use checkboxes as they permit yes, no AND not
applicable from being selected. Use a radio button group instead, here the user can only select yes, no OR not applicable. Next, use VBA to arrange the data in an output format that you need... -- Gnothi se auton. "CaptainCrumpet" wrote: Greetings, Sorry if this is a stupid question. I have a spreadsheet and i want to enter 3 rows of boxes that i can simply click on to tick or untick them. Its for a questionnaire so answers will vary from one person to another so i would just like to click on the boxes to enter the tick for either a yes, no, or not applicable answer. I hope this makes sense, i already have the spreadsheet i want with this tick/untick facility but its locked so i cant amend it to meet my needs :o( hope someone can help otherwise im gonna have to start drinking this lunchtime!!! If someone could lay out a simple step by step process i would be most grateful! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i create a tick box in excel? 2003 version | Excel Worksheet Functions | |||
Method for inserting a check-mark/tick-box in Excel | Excel Discussion (Misc queries) | |||
How can I add tick boxes to my Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Tick Boxes | Excel Worksheet Functions | |||
Copying Tick Boxes | Excel Worksheet Functions |