View original (French)

Display text by checking a box

gillesdn Posted messages 3 Status Member -  
gillesdn Posted messages 3 Status Member -
Hello,

I have read many articles on this topic, but I never quite arrived at what I wanted. Having no real foundation for macros in Excel, I find it very difficult to understand coding.

I am a kitchen designer and would like to create a checklist to validate the options chosen by my clients.
I would like that when I check the box "under-mounted sink", for example, it automatically displays the phrase "Under-mounted sink (glued underneath the countertop)" in the area at the bottom of the document.

So I would like that checking the different options creates a summary text of the choices made by my client. Is that possible?

I don't know if I am being very clear in my explanation.
Thank you in advance for your feedback!

Gilles

2 answers

  1.
    danielc0 Posted messages 2221 Registration date   Status Member Last intervention   296
     
    Hello,

    Try adding a checkbox, for example in C6. Right-click on it and choose "Format Control". Click on the "Control" tab. Set B6 as the linked cell.
    In D6, test:
    =IF(B6=TRUE; "Undermount sink (glued from underneath the countertop)"; "")

    Best regards.

    Daniel
    1
    1. gillesdn Posted messages 3 Status Member
       
      Hello Daniel,

      Thank you very much, it's exactly what I wanted to do!

      Do you know how I can get rid of the "true" or "false" that appears in B6?

      Have a great day!

      Gilles
      0
  2. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello

    An idea in the file with the explanations
    this goes in the same direction as danielc0's response

    https://www.cjoint.com/c/IEEmDP6q4zx

    --
    It's by forging that one becomes a blacksmith. - It’s at the foot of the wall that one sees the mason - we always learn from our mistakes.
    1
    1. gillesdn Posted messages 3 Status Member
       
      Thank you, Philou, it’s perfect!

      Have a great day!

      Gilles
      0