Checkbox which creates text in another cell

[rippedit123]

hi everyone,

thank you for a wonderful forum. I'm trying to create a checklist, so that when I checkmark a checkbox, rather than it simply stating true/false, it actually creates a text message in another cell.

So say for example my question is "What GCSE subject choices are available?"
Then there is a checklist which says:-
1. ENGLISH
2. MATHS
3. CHEMISTRY

Depending on which checkboxes I tick, I want the word's ENGLISH, MATHS, CHEMISTRY to appear in another cell as text in another cell as comments.

Here is what is should look like:

Image2.jpg

[newdoverman]

Insert the checkboxes where you want them and delete the text that is with the checkbox. Click on the properties button and link the check box to the cell under the checkbox. Select the cell under the checkbox and format the font to be white so that text will not show. Where you want the message if checked enter a formula such as this.

This example assumes the checkbox is in B2 and the cell linked to the checkbox is B2. Where you want the response if checked enter this formula which will enter your text when the checkbox is checked and a blank cell if not checked. Replace the "" with text between the " " for the checkbox being unchecked if you need that:

Please Login or Register  to view this content.

[rippedit123]

Thank you very much newdoverman for your help. It's really appreciated.

Now I want to make it as easy as possible for my colleagues, so that most of the process is automated. So here is a complex scenario....

Mr Smith owes me some money for June 2015, Aug 2015 and I want to create commonly typed notes as quickly as possible.

I want to have a check-box type of system, so firstly how would I be able to use excel to say "Mr Smith owes me for JUNE 2015, AUG 2015"?

but if I now realise he also has an outstanding bill for DEC 2015, I also want to be able to add/delete as necessary to say "Mr Smith owes me for JUNE 2015, AUG 2015, DEC 2015"


Is this possible?

[newdoverman]

A full explanation of what you want is in order. This is drastically different from your original question. How is your data organized and how do you expect to use checkboxes to achieve what you want? This sounds like a billing system that one would expect from a Utility Company like the Telephone company.....correct?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[rippedit123]

Please accept my apologies newdoverman for not explaining clearly. The truth is that this spreadsheet I'm trying to create is to help me at work to make writing notes on the system more automated and thus easier. I've sent you a PM to explain my situation better and would be most grateful if you could reply via PM.