Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting check boxes
I am trying to insert check boxes in an entire column - imagine list of
tasks, checking them off as completed. The only thing I can figure out is an insert symbol - any help appreciated!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting check boxes
Go to ViewToolbarsForms and chose check box from the menu.
-- Please post all your inquiries on this community so we can all benefit - Thank you! "April "I''m not quite sure..."" wrote: I am trying to insert check boxes in an entire column - imagine list of tasks, checking them off as completed. The only thing I can figure out is an insert symbol - any help appreciated!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting check boxes
Do the following:
1. On the View menu, point to Toolbars and then click Forms. 2. On the View menu, point to Toolbars and then click Visual Basic. To toggle betwen Design Mode and Exit Design mode. You can modify any Form element only in Design Mode or by right clicking the the form element and selecting the appropriate options from the pop-up menu. 3. Click the Design mode icon in the Visual basic and then click the check box button on the Forms Toolbar. 4. Drag and drop on the Excel sheet. 5. Click the check box you have placed on the sheet, and pressing the Ctrl key drag to make copy of these check boxes. 6. Click the Design buttin on the Visual Bascic tool bar to Exit the Design mode. Challa Prabhu "April "I''m not quite sure..."" wrote: I am trying to insert check boxes in an entire column - imagine list of tasks, checking them off as completed. The only thing I can figure out is an insert symbol - any help appreciated!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting check boxes
Forgot to include a important procedure.
Finally, In the options dialogbox, click OK in the Save Tab. Challa Prabhu "challa prabhu" wrote: Do the following: 1. On the View menu, point to Toolbars and then click Forms. 2. On the View menu, point to Toolbars and then click Visual Basic. To toggle betwen Design Mode and Exit Design mode. You can modify any Form element only in Design Mode or by right clicking the the form element and selecting the appropriate options from the pop-up menu. 3. Click the Design mode icon in the Visual basic and then click the check box button on the Forms Toolbar. 4. Drag and drop on the Excel sheet. 5. Click the check box you have placed on the sheet, and pressing the Ctrl key drag to make copy of these check boxes. 6. Click the Design buttin on the Visual Bascic tool bar to Exit the Design mode. Challa Prabhu "April "I''m not quite sure..."" wrote: I am trying to insert check boxes in an entire column - imagine list of tasks, checking them off as completed. The only thing I can figure out is an insert symbol - any help appreciated!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check boxes | Excel Discussion (Misc queries) | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
Inserting check boxes | Excel Worksheet Functions | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) |