using control form checkbox in excel

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,556
Hi
I want to ask a question to the user and give 3 choices answers.

Q) What is the color of the sky?

[x] blue
[] red
[] green

C1 = correct

If user click on Blue then C1 will show correct. So I linked the first checkbox to B1 and I wrote in C1 the following

=if(B1=true, "Correct", " wrong")

I can do this, but my question, how can I do the reset. I mean if user click on Red or Green, I want C1 show "Wrong"

I am thinking of 3 If(). Do you have better idea? Thank you so much.
 
Last edited:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,909
Office Version
365
Platform
Windows
Why not use option buttons instead?
That way you check if B1 is 1, 2 or 3
 

Forum statistics

Threads
1,085,960
Messages
5,386,943
Members
402,025
Latest member
saresum

Some videos you may like

This Week's Hot Topics

Top