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.