ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inserting check boxes (https://www.excelbanter.com/excel-discussion-misc-queries/138428-inserting-check-boxes.html)

April I''m not quite sure...

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!!

Adnan

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!!


challa prabhu

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!!


challa prabhu

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!!



All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com