Excel, conditional checkbox? Solved

Question

Hello,

Here's my question about Excel.

I have added checkboxes to my document. I would like a number to appear in a cell when they are checked, and when not checked, nothing should show in that same cell.

Conversely, how do I include the checkbox in the IF function?? Or is there another function?

Thank you for your help (I'm quite a beginner with Excel)...

Configuration: Windows XP Firefox 3.0.10

Mike-31 · Accepted Answer

Re,

Yes, absolutely, with Excel there are only solutions.

So right-click on your checkbox and go to control format, in the linked cell select a cell, for example A1, which will serve to control your checkbox and in which TRUE or FALSE will be recorded depending on whether your checkbox is checked or not.

Then in another cell the formula is simple

=IF(A1=TRUE,125,"")

If you have some knowledge of VBA it would be preferable to go through the control bar and enter a VBA

A+--

A problem without a solution is a poorly posed problem (Einstein)

pijaku · Answer

Hello Asfero,
Why stay "anonymous," register on CCM and ask any questions you want... note that you can also ask them as a non-registered user, but it’s much less nice (at least for the person responding).
Then, for question 1, let’s assume you want to enter 125 in cell (and yes, in Excel we talk about cells, not boxes) A1:
- double click on the checkbox
A VBA window opens with this inside:
Private Sub CheckBox1_Click()

End Sub
write this between private sub... and end sub:
If CheckBox1.Value = True Then
[A1] = "125" 'here you can modify the destination cell and the number to indicate
End If
so you see:

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
[A1] = "125"
End If
End Sub

and close the window
There you go.
--
What is worth doing is worth doing well.

pijaku · Answer

Re-
a small variation if you want that when you uncheck the checkbox you have nothing written in your destination cell:

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then 'If checkbox = true (therefore checked)
[A1] = "125" 'write 125 in cell A1
Else ' otherwise
[A1] = "" ' write nothing (considered "erasing") in A1
End If
End Sub

--
What is worth doing is worth doing well.

Asfero · Answer

Hello
thank you for the answers

actually I'm a bit rushed, I will sign up later...

I'm trying to click twice on the checkbox but all that happens is it gets checked and unchecked..... isn't there another way with a reference to the checkbox and the IF function??

Thanks for your help

Mike-31 · Answer

Hi everyone,  We need to check which toolbox the checkboxes were created with, form bar or control box  A+--   A problem without a solution is a poorly posed problem (Einstein)

Asfero · Answer

form bar....  do you have a solution??

Asfero · Answer

Hi  I achieved something, but it displays true or false, and this cell is linked to my other cell. Is there any way to change those values or bypass the true/false cell???

Asfero · Answer

Hi

Thank you for your response, but I just understood this process.... what annoys me is having to go through a cell that indicates true or false, there’s no way to delete this cell and have the checkbox directly give, I don't know, 0 or 1?

Otherwise, when I open the VBA I really don't see what I've been described.....

Mike-31 · Answer

Re,

With the solution our friend pijaku proposed, you display the Visual Basic Editor toolbar, click on the checkbox on the toolbar, draw your box with the mouse and double click on it, which will open a blank sheet with --
Private Sub CheckBox1_Click()

End Sub

paste pijaku's code between the two lines

If CheckBox1.Value = True Then 'If checkbox = true (then it is checked)
[A1] = "125" 'write 125 in cell A1
Else ' otherwise
[A1] = "" ' write nothing (see "clear") in A1
End If

Cya

A problem without a solution is a poorly posed problem (Einstein)

Asfero · Answer

Hi  I just tried in VBA and once I've created my checkbox, how do I check it?? To see if what I wrote in the script works??

Asfero · Answer

Hi, okay I just understood!!!

Now I have another small question.

Instead of using a number, is it possible to refer to another cell??

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
[F50] = "D50"
Else
[F50] = ""
End If
End Sub

Let's say I want to refer to cell D50???

Thanks

Asfero · Answer

and also how to remove the name of the object checkbox 1 for example???  thank youuuuuu

pijaku · Answer

Re-
To do what you asked, I used the command toolbar.
Indeed, as mentioned earlier (post 9) by our friend Mike, you need to draw your checkbox and double-click it. Then complete with the aforementioned VBA code...
When you close VBA, you return to Excel and there you need to click on the icon in the "commands" toolbar, which represents a set square, a pencil, and a ruler, to change mode.
After that, it should work...
--
What is worth doing is worth doing well.

Asfero · Answer

Thank you Pijaku and Mike, but my problem is this hehe

Instead of putting a number, is it possible to refer to another cell?

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
[F50] = "D50"
Else
[F50] = ""
End If
End Sub

Let’s say I want to refer to cell D50???

Thank you

Mike-31 · Answer

Re,

Replace this line

[F50] = "D50"

with

[F50] = Range("D50")
[F50] = [D50]

To clear--
checkbox 1

Switch to design mode by clicking on the second to last button in the Visual Basic toolbar, double click on the checkbox to hide, which will open the properties of your checkbox. In the left margin (properties Checkbook1 find Caption, next to it you'll have Checkbook1, delete it or give a name to your box

A+

A problem without a solution is a poorly posed problem (Einstein)

Asfero · Answer

IT'S AWESOME !!!!!!!!!!!!!  Thank you all for your patience !!!!!!!!!

Mike-31 · Answer

Hi,

Don't forget to mark your status as resolved or ask the moderation team to do it for you by clicking on the triangle of the last post.

Follow our friend pijaku's advice, sign up as a member, it's more friendly.

See you later--

A problem without a solution is a poorly posed problem (Einstein)

Excel, conditional checkbox?

17 réponses

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

Black screen digital camera

Connecting rj45 cable with fiber

Sony bravia tv red led blinks 4 times

Free: associating with the freebox server in progress

Inuyasha in french

Ccleaner starts at boot.