Results 1 to 2 of 2

Thread: using control form checkbox in excel

  1. #1
    Board Regular
    Join Date
    Mar 2016
    Posts
    1,395
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default using control form checkbox in excel

    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 by lezawang; Sep 22nd, 2019 at 12:38 AM.

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,228
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: using control form checkbox in excel

    Why not use option buttons instead?
    That way you check if B1 is 1, 2 or 3
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •