How Do I Create a Checkbox in Excel
How to Create a Check Box in Excel 2007
- Small Business |
- Accounting & Bookkeeping |
- Excel
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.
Form Control
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." Select the "Show Developer Tab in the Ribbon" check box and click "OK."
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. 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."
ActiveX Controls
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." Select the "Show Developer Tab in the Ribbon" check box and click "OK."
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.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.
References
Tips
- 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.
Writer Bio
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.com and "Adobe Magazine." Cox holds a professional certificate in technical communications from the University of Washington.
How Do I Create a Checkbox in Excel
Source: https://smallbusiness.chron.com/create-check-box-excel-2007-40656.html
0 Response to "How Do I Create a Checkbox in Excel"
Post a Comment