| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating form with "tick boxes"
i want to create a form, in which you can select certain criteria by clicking
a cell, and then in that cell a tick (or dot, or anythng!) appears highlighting your choice without you having to actually type anything in the cell. i currently use Excel 2003 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating form with "tick boxes"
How about an actual check box. What you are describing would require some
custom macro code. This is a pile easier... Bring up the Forms Toolbar (Tools - Customize - Toolbars - Forms Toolbar) There is a check box icon on the bar. Select it. Now on your worksheet you can draw a checbox by dragging your cursor. Right click the check box to Edit the text to a meaningful caption. Right click the check box and select Format Control. On the Control Tab add a cell reference to linked cell. When the check box is checked or unchecked the linked cell will show true or false... -- HTH... Jim Thomlinson "Jane13" wrote: i want to create a form, in which you can select certain criteria by clicking a cell, and then in that cell a tick (or dot, or anythng!) appears highlighting your choice without you having to actually type anything in the cell. i currently use Excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
| how to eliminate E-mail "To" & "CC" boxes at top of Excel Sheet | Excel Discussion (Misc queries) | |||
| function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
| cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) | |||
Linear Mode
