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

Answer 1 / 2
danielc0 Posted messages 2173 Registration date   Status Member Last intervention   285
 
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
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
Answer 2 / 2
PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   834
 
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
gillesdn Posted messages 3 Status Member
 
Thank you, Philou, it’s perfect!

Have a great day!

Gilles
0