MACRO - Autopopulate message with checkboxes

Is it possible for Excel Macro to provide a summary from a set of checklist boxes? I am OK with the checklist side of things, but can't seem to figure out the summary macro side of things.

For example:

5kg apple, Tick (YES/NO)
2kg tomatoes, Tick (YES/NO)
5kg cucumbers, Tick (YES/NO)
1kg mushrooms, Tick (YES/NO)

Let's say I tick YES for 5kg apple + 5kg cucumbers - Is it possible to have a summary message to state as follows:

Today's incoming inventory is as follows:
* 5kg apple
* 5kg cucumbers

Thats it - the macro only needs to create a summary and copy to clipboard that I can paste to an email message.

Are you looking for a userform to input the information or are you just wanting to pull the information from the checkbox on the excel sheet. For the e-mail is there certain person it is going to always be e-mailed to or is it going to be different all the time?

Not sure if this is what you are looking for, but here’s what I came up with. It has the ability to send an e-mail through outlook via the e-mail button. Also put another macro in that will store the info to the clipboard so that you can paste it in where you need it…. This one is more along the lines of what you asked for! If these do not work for what you need please let us know so that we can try to help adjust the macro to do more along the lines of what you need!

I attached a Sample file to see if this is what you need

Auto E-mail

Please Login or Register  to view this content.

Copy to clipboard

Please Login or Register  to view this content.

Thank you for the macro codes meabrams, that helped greatly. I noticed you used similar macro for the email that I also use from rondebruin.nl

I am trying to understand the new codes for the checkbox on how it works, the final macro will have over 20 checkboxes (I just used 5 as an example), is it possible to squeeze the summary down from: (for example)

* 5kg apple
SPACE
SPACE
* 1kg mushrooms

TO

* 5kg apple
* 1kg mushrooms

I am trying to create a condensed clean summary sans the line feed in between them.

I will look into eliminating the extra spaces just was trying to get this working first then fine tune after the I found out if this is what you are looking for
You said that you have 20 plus checkboxes I would need to know exactly how many you have in order to adjust the macro to fit your needs

Excellent! =D

Many thanks Meabrams - sorry for the late reply, I was off sick with the flu

I am learning quite a few new codes from your script I have never encountered before.

With regards to the following code:

Please Login or Register  to view this content.

You used the actual caption of the Checkbox

I have my checkbox on one cell, description in the other where I can impose conditional formatting as per attached XLSM file.

Is it still possible for each checkbox to read another cell's text?