Results 1 to 19 of 19

CHECKBOX in cells

Threaded View

  1. #1
    Registered User
    Join Date
    09-22-2015
    Location
    London
    MS-Off Ver
    MS365 Enterprise Version 2310
    Posts
    58

    CHECKBOX in cells

    Hi

    I am trying to place checkboxes in multiple cells (for an attendance tracker) but would like to do this without using the developer tab and Form Control (but using Cell Control). I would simply like users to click on the checkbox (which puts a tick in it) as I have a final column which calculates a % of how many ticks ie. completed tasks. I don't think I can calculate percentages if I use Form Control via the developer tab.

    I cannot find anywhere on my version of Excel how to do it. There used to be a 'checkbox' option (next to comment, link etc.) when you clicked on the INSERT tab on the Excel ribbon but it's not there now.

    I have tried other ways like data validation but there's no option for checkbox on that either.

    Can anyone help me? I've attached an image of where the CheckBox is/was supposed to be ... but it's not on my ribbon.

    TIA
    Attached Images Attached Images
    Last edited by F1ash; 11-16-2023 at 02:37 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Deactivate cells based on checkbox selection and exclude inactive cells from SUM
    By olga6542 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-14-2019, 01:20 PM
  2. Replies: 1
    Last Post: 07-12-2019, 12:18 PM
  3. Checkbox to add formula in cells
    By bdouglas1011 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-08-2018, 05:46 AM
  4. Checkbox to SUM cells
    By ricfig in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-07-2016, 12:42 PM
  5. Checkbox on / off applying to cells only in the same row as the checkbox
    By Grimace in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-12-2012, 08:28 PM
  6. [SOLVED] Adding a Checkbox in Cells
    By Chaplain Doug in forum Excel General
    Replies: 3
    Last Post: 05-15-2006, 11:10 AM
  7. [SOLVED] Need checkbox automatically in some cells of a new row
    By stuff8458 in forum Excel General
    Replies: 0
    Last Post: 11-08-2005, 05: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