Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box - true/false - i'd like a third option n/a
Hey,
i have a questionnaire - i'd like check boxes, but instead of the true/false i'd like three options true/false/na. True being a tick, false being nothing and na being greyed out or something such like.... I have ssen this done in Access but not sure if it can been done in excel - could anybody help me? Thank you -- kelly m johnson London UK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box - true/false - i'd like a third option n/a
You must set the Triplestate of each checkbox to True.
Each time you click on the checkbutton, it changes: TRUE/FALSE/#N/A See example: http://cjoint.com/?gbsWZ1p3p3 HTH -- AP "Kelly 1st" a écrit dans le message de news: ... Hey, i have a questionnaire - i'd like check boxes, but instead of the true/false i'd like three options true/false/na. True being a tick, false being nothing and na being greyed out or something such like.... I have ssen this done in Access but not sure if it can been done in excel - could anybody help me? Thank you -- kelly m johnson London UK |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box - true/false - i'd like a third option n/a
Hey,
triplestate? I'm afraid i'm not that advanced... do you think you could explain a little more please? Thank you for your time -- kelly m johnson London UK "Ardus Petus" wrote: You must set the Triplestate of each checkbox to True. Each time you click on the checkbutton, it changes: TRUE/FALSE/#N/A See example: http://cjoint.com/?gbsWZ1p3p3 HTH -- AP "Kelly 1st" a écrit dans le message de news: ... Hey, i have a questionnaire - i'd like check boxes, but instead of the true/false i'd like three options true/false/na. True being a tick, false being nothing and na being greyed out or something such like.... I have ssen this done in Access but not sure if it can been done in excel - could anybody help me? Thank you -- kelly m johnson London UK |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box - true/false - i'd like a third option n/a
Is your questionaire a nicely designed worksheet?
If yes, you can use the checkbox from the Control toolbox toolbar. Right click on that checkbox and choose properties. Scroll to Triplestate and make that property True Scroll to LinkedCell and type in an address Then click on the design mode icon (another icon on that control toolbox toolbar). Now click on that checkbox a few times and watch the linked cell and the checkbox itself. Kelly 1st wrote: Hey, triplestate? I'm afraid i'm not that advanced... do you think you could explain a little more please? Thank you for your time -- kelly m johnson London UK "Ardus Petus" wrote: You must set the Triplestate of each checkbox to True. Each time you click on the checkbutton, it changes: TRUE/FALSE/#N/A See example: http://cjoint.com/?gbsWZ1p3p3 HTH -- AP "Kelly 1st" a écrit dans le message de news: ... Hey, i have a questionnaire - i'd like check boxes, but instead of the true/false i'd like three options true/false/na. True being a tick, false being nothing and na being greyed out or something such like.... I have ssen this done in Access but not sure if it can been done in excel - could anybody help me? Thank you -- kelly m johnson London UK -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box - true/false - i'd like a third option n/a
Dave what type of address do I put in the linkedcell feild to shade the check
box "Dave Peterson" wrote: Is your questionaire a nicely designed worksheet? If yes, you can use the checkbox from the Control toolbox toolbar. Right click on that checkbox and choose properties. Scroll to Triplestate and make that property True Scroll to LinkedCell and type in an address Then click on the design mode icon (another icon on that control toolbox toolbar). Now click on that checkbox a few times and watch the linked cell and the checkbox itself. Kelly 1st wrote: Hey, triplestate? I'm afraid i'm not that advanced... do you think you could explain a little more please? Thank you for your time -- kelly m johnson London UK "Ardus Petus" wrote: You must set the Triplestate of each checkbox to True. Each time you click on the checkbutton, it changes: TRUE/FALSE/#N/A See example: http://cjoint.com/?gbsWZ1p3p3 HTH -- AP "Kelly 1st" a écrit dans le message de news: ... Hey, i have a questionnaire - i'd like check boxes, but instead of the true/false i'd like three options true/false/na. True being a tick, false being nothing and na being greyed out or something such like.... I have ssen this done in Access but not sure if it can been done in excel - could anybody help me? Thank you -- kelly m johnson London UK -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box - true/false - i'd like a third option n/a
Leave the cell empty.
JHanner wrote: Dave what type of address do I put in the linkedcell feild to shade the check box "Dave Peterson" wrote: Is your questionaire a nicely designed worksheet? If yes, you can use the checkbox from the Control toolbox toolbar. Right click on that checkbox and choose properties. Scroll to Triplestate and make that property True Scroll to LinkedCell and type in an address Then click on the design mode icon (another icon on that control toolbox toolbar). Now click on that checkbox a few times and watch the linked cell and the checkbox itself. Kelly 1st wrote: Hey, triplestate? I'm afraid i'm not that advanced... do you think you could explain a little more please? Thank you for your time -- kelly m johnson London UK "Ardus Petus" wrote: You must set the Triplestate of each checkbox to True. Each time you click on the checkbutton, it changes: TRUE/FALSE/#N/A See example: http://cjoint.com/?gbsWZ1p3p3 HTH -- AP "Kelly 1st" a écrit dans le message de news: ... Hey, i have a questionnaire - i'd like check boxes, but instead of the true/false i'd like three options true/false/na. True being a tick, false being nothing and na being greyed out or something such like.... I have ssen this done in Access but not sure if it can been done in excel - could anybody help me? Thank you -- kelly m johnson London UK -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check box help | Excel Discussion (Misc queries) | |||
... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
Visual basic Check Box and the IF formula | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
Auto Spell Check | Excel Discussion (Misc queries) |