How to put checkbox in excel 2003
Using Excel to create business forms means including elements available on your Web-based and paper forms, including check boxes. Like other Excel form elements, check boxes appear on the drawing layer above a spreadsheet, and aren't affected by changes to a spreadsheet's cells unless you specifically link them to a cell.
A check box in Excel can use either Excel's form controls or ActiveX controls for formatting. Form controls offer simple formatting, as well as the ability to add a check box to a chart sheet or use it to control a macro. ActiveX controls offer more design flexibility by using Visual Basic for Applications to specify properties, and you can use VBA to trigger events and run macros based on interaction with the check box.
Display the "Developer" tab if it doesn't already appear in Excel's ribbon. To display the "Developer" tab, click the Microsoft Office Button, click the "Excel Options" button and click "Popular. Click the "Developer" tab, click "Insert," choose a check box from the "Form Controls" section, and click the worksheet where you want to place the check box.
Using Check Boxes (Microsoft Excel)
You can adjust the check box's position by dragging its border, or resize its bounding box by dragging its control points. Select the text and type to add your own label beside the check box.
Click "Properties" in the "Controls" group of the "Developer" tab, or right-click the check box and choose "Format Control" to open the Format Control dialog box. When working with a Form Control check box, you can adjust its look and feel as well as specify a cell link that will hold its value. When checked, the box returns a value of "TRUE," and when unchecked the box returns "FALSE. Click the "Developer" tab, click "insert" and choose a check box from the "ActiveX Controls" section, and click the worksheet where you want to place the check box.
Not allowed.
You can adjust the check box's position by clicking anywhere within its bounding box and dragging it, or resize the bounding box by dragging its control points. Right-click the check box and choose "Format Control" to open the Format Control dialog box. For an ActiveX Control check box, you can adjust the bounding box size and rotation, protection, alternate Web text, relative positioning and print appearance.
Click "Properties" in the "Controls" group of the "Developer" tab or right-click the check box and choose "Properties" to open the Properties dialog box and enter the values you prefer for each feature.
If you're unfamiliar with the VBA values for a property, click the property name and press the F1 key to open the Visual Basic Help topic for that property. To add VBA scripting, double-click the check box to open Microsoft Visual Basic.
MS Excel Update a cell when a checkbox is clicked (Forms toolbar)
Michael Cox writes about lifestyle issues, popular culture, sports and technology. In a career spanning more than 10 years, he has contributed to dozens of magazines, books and websites, including MSN. Skip to main content. Tip The size of the check box, as well as its distance from its text label, are not adjustable as either a form or ActiveX control.
References 2 Microsoft Office Support: Add a Check Box, Option Button, or Toggle Button to a Worksheet Microsoft Office Support: Overview of Forms, Form Controls, and ActiveX Controls on a Worksheet. About the Author Michael Cox writes about lifestyle issues, popular culture, sports and technology.
Suggest an Article Correction.
More Articles [VBScript Using Excel] How to Make a Button in VBScript Using Excel [Form Using Microsoft Excel] How to Create a Form Using Microsoft Excel [Averages] How to Do Averages With Percentages in Excel [Business Card] Can You Format a Business Card in Excel?
Also Viewed [MS Excel] How to Run an Event in MS Excel If a Cell Is Selected [Excel Checklist Creator] Excel Checklist Creator [Multiple Selections] How to Make a Drop Down Box to Allow Multiple Selections in Excel [Drop] How to Create a Drop Down Box in Word [Microsoft Excel] How to Put a Signature on Microsoft Excel [Check Box Form Field] Adding a Check Box Form Field With the Legacy Tool in Microsoft Word [Check Boxes] How to Work With Check Boxes in Word.
Logo Return to Top.
Contact Customer Service Newsroom Contacts. Connect Email Newsletter Facebook Twitter Pinterest Google Instagram. Subscribe iPad app HoustonChronicle.