Introducing Checkboxes in Excel

What is the cell value of the checkbox?  For instance might it be "1" or "0" so that I can use it in an IF conditional statement.  Then if checked, can do something but if not, leave it blank.

If it's checked it returns true / 1, if it's not it returns false / 0. 

It's similar to the legacy activeX checkboxes, but now it's direcly connected to the cell!

DavidG323 The value is TRUE / FALSE so you will be able to use it in formulas or conditional formating for example...

GKN1999 , that's only to wait, deployment takes entire July, wave, by wave.

Hello mark_htb, the Enterprise Monthly Channel receives features monthly, on the second Tuesday of the month, typically trailing Current Channel by 4-8 weeks. Doing that math, Checkboxes are most likely to hit Enterprise Monthly in the August or September release.

You can find more information on channels and their timelines here: Overview of update channels for Microsoft 365 Apps - Deploy Office | Microsoft Learn

You can also create a checkbox toggle with Wingdings (o in Wingdings is a blank checkbox, x in Wingdings is a filled checkbox). 

I made a video about how to do this, but if you just want the code, I have that below too.  I used the Wingdings in Column C, just make sure to revise the code as needed. 

YouTube Video: https://youtu.be/sgDZvJlooVU 

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    ' Specify the range where the checkboxes are located (column C)
    If Not Intersect(Target, Me.Range("C:C")) Is Nothing Then
        Cancel = True ' Prevents entering edit mode on double-click
        
        ' Check if the font is Wingdings and if it is a checkbox (either "o" or "x")
        If Target.Font.Name = "Wingdings" Then
            If Target.Value = "o" Then
                ' If the value is "o", change it to "x" (checked box)
                Target.Value = "x"
            ElseIf Target.Value = "x" Then
                ' If the value is "x", change it back to "o" (unchecked box)
                Target.Value = "o"
            End If
        End If
    End If
End Sub

DavidG323, to confirm as Stefan_Alexandrov and Lukas_Kucharczyk suggested,

The value of a Checked checkbox is TRUE

The value of an Unchecked checkbox is FALSE

If you would like to write formula that's easier with 1/0, a useful trick is multiplying the TRUE/FALSE by 1. (FALSE*1 = 0, TRUE*1 = 1)

This is a link to the help article for Checkboxes which has some more detail: Using Checkboxes in Excel - Microsoft Support. I've also added the link to the blog post itself.

If the checkbox is created in Excel for Windows, will it function if that same spreadsheet is opened in Excel for Web?  Asking for collaboration use.

cookt yes, this feature will be compatible with all Excel platforms.

I’ve been awaiting this feature for quite some time now, I’m so excited to see it finally arrive! Thank you! I can finally switch to the superior spreadsheet software. 😄