+ Reply to Thread
Results 1 to 7 of 7

Insert Checkbox WITHOUT Drawing / Add to Toolbar or Ribbon

  1. #1
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,054

    Question Insert Checkbox WITHOUT Drawing / Add to Toolbar or Ribbon

    Hi Group

    How to add checkbox to Toolbar and/or Ribbon?



    Is there an extension or something?

    I want check box to properly align in center both vertically and horizontally within cells WITHOUT having to MANUALLY draw in and reposition?

    Using Excel 365

    Example pic shown:
    Attached Images Attached Images
    Last edited by mycon73; 01-02-2024 at 12:38 AM.
    MyCon
    -- Using Latest Version of Excel

  2. #2
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,054

    Re: Insert Checkbox WITHOUT Drawing / Add to Toolbar or Ribbon

    Hi Group

    I'm seen check box options in handful of tutorial video but haven't figured out on how to add it into toolbar and/or ribbon.

    I want check box to properly align in center both vertically and horizontally within cells WITHOUT having to MANUALLY draw in and reposition it several times.

    Using Excel 365

    Thanks

  3. #3
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Re: Insert Checkbox WITHOUT Drawing / Add to Toolbar or Ribbon

    Fairly sure you would need to have some sort of VBA.

    Found this youtube video - https://www.youtube.com/watch?v=zFl9dKhH298

    Which worked for me when I added the VBA to a .xlsm file, maybe you could add a button or a guru might be able to help with making the VBA automate on an event.

  4. #4
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Insert Checkbox WITHOUT Drawing / Add to Toolbar or Ribbon

    This new feature check box don't need alignment.

    Excel's NEW Checkboxes Are Incredibly Cool! Here's why

    NEW: How to Add Checkbox in Excel

    I have a 365 but it isn't available for me..
    Last edited by DJunqueira; 01-02-2024 at 04:05 AM.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Insert Checkbox WITHOUT Drawing / Add to Toolbar or Ribbon

    The NEW checkbox is to be found on the INSERT ribbon as standard.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  6. #6
    Registered User
    Join Date
    02-23-2024
    Location
    Texas
    MS-Off Ver
    365
    Posts
    2

    Re: Insert Checkbox WITHOUT Drawing / Add to Toolbar or Ribbon

    I cannot get the new checkbox insert button. I have signed up for Insider, updated my 365 software and still don't have the insert checkbox command on the ribbon. Have also checked "Options" and it is not in Customize Ribbons. What am I doing wrong or not doing?

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Insert Checkbox WITHOUT Drawing / Add to Toolbar or Ribbon

    This is NOT your thread - please review the rule on hijacking.

    I shall let it go this time and simply repeat that checkboxes are avaialble in the Insider BETA, so you would need to be signed up for that. If that's the version you are running, then you should be able to find it, either already on the Insert ribbon or in the customisation options.
    Attached Images Attached Images
    Last edited by AliGW; 03-17-2024 at 10:46 AM. Reason: Typo fixed.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 : Drawing Toolbar Disabled
    By yellephant in forum Excel General
    Replies: 0
    Last Post: 11-16-2010, 12:52 PM
  2. cant see drawing toolbar
    By Nicky in forum Excel General
    Replies: 10
    Last Post: 05-23-2007, 08:13 AM
  3. [SOLVED] drawing toolbar
    By LWright in forum Excel General
    Replies: 0
    Last Post: 08-10-2006, 01:55 PM
  4. Text box in drawing toolbar in Excel
    By B.W. in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-16-2006, 02:35 AM
  5. In Drawing toolbar, All Characters and Symbols of the keybord sho.
    By Parantap in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-15-2006, 09:25 AM
  6. Missing drawing toolbar in Excel 2000
    By Ken Roberts in forum Excel General
    Replies: 2
    Last Post: 02-14-2006, 12:15 PM
  7. [SOLVED] Drawing Toolbar Functions in Excel
    By EmBee in forum Excel General
    Replies: 2
    Last Post: 01-27-2006, 04:20 PM
  8. [SOLVED] drawing toolbar icons
    By cgardnerrn in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-02-2006, 02:10 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1