Results 1 to 5 of 5

Thread: add Checkbox in Ms Excel spreadsheet

  1. #1
    Join Date
    Aug 2008
    Posts
    69

    add Checkbox in Ms Excel spreadsheet

    Hi,

    I know this sounds really a basic question but i am not sure.
    I want some help about the checkbox in Microsoft excel. I want to create a simple checklist for my spreadsheet. Please shed some light.

  2. #2
    Join Date
    Oct 2008
    Posts
    65

    Re: add Checkbox in Ms Excel spreadsheet

    To select the checkbox Control: Select view of Toolbars, then drag checkbox to place on your screen. Do the same for the form toolbar, you will not have to write code for information or to make up when the box is checked. The control box is the user form of the Visual Basic Editor made but works much the same way.

  3. #3
    Join Date
    May 2008
    Posts
    248

    Re: add Checkbox in Ms Excel spreadsheet

    Add a control to the toolbar of Forms. To control an existing macro I want to run, open the workbook that contains macros. Click the worksheet where you want to add the control. Display the Forms toolbar: the point to Toolbars on the menu, and then click Forms. Click the button on the control you want to add. For the worksheet, drag the control to the size you want. Do one of the following: Assign an existing macro to if you're adding a node, select the macro button in the Macro Name box to run. If you're adding a control outside a button, click the check right on, and click Assign Macro on the shortcut menu. Select the macro you want. Register As of writing a new macro the macro exists, click Report in the Assign Macro dialog box to record a new macro, or click New to Microsoft's Visual Basic for Applications module (VBA) macro to open where you can write. Click the right to control, then gives the text, and then add the text for checking. If you right-click the control and then click Edit Text & finish. Set control properties.

  4. #4
    Join Date
    Apr 2008
    Posts
    61

    Re: add Checkbox in Ms Excel spreadsheet

    In the menu bar select view then select the toolbars. Make sure the Forms toolbar is checked ... You would have to have a button in your tool bars that will add check box.

  5. #5
    Join Date
    May 2008
    Posts
    42

    Re: add Checkbox in Ms Excel spreadsheet

    about check boxes, option buttons, and toggle buttons

    Check box Turns on or off a value that indicates an opposite and unambiguous choice. You can select more than one check box at a time on a worksheet or in a group box. For example, you can use a check box to create an order form that contains a list of available items or in an inventory tracking application to show whether an item has been discontinued.

Similar Threads

  1. How to setup Excel Spreadsheet on Computer
    By Raju Chacha in forum Microsoft Project
    Replies: 2
    Last Post: 08-01-2012, 09:06 PM
  2. Excel 2007 - insert button, checkbox, combo box etc.
    By Hardik in forum MS Office Support
    Replies: 3
    Last Post: 06-10-2011, 07:38 PM
  3. Can We Auto-Run Excel Spreadsheet.??
    By Dilbert in forum Windows Software
    Replies: 4
    Last Post: 02-01-2010, 09:09 PM
  4. Importing Excel Spreadsheet
    By Theodore Long in forum Microsoft Project
    Replies: 3
    Last Post: 05-06-2009, 09:02 AM
  5. Corrupt spreadsheet in excel
    By Indrani in forum Windows Software
    Replies: 3
    Last Post: 06-05-2009, 03:12 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,603,551.20836 seconds with 17 queries