Emailing CheckBox Label Value

Hi Folks,

Quick question that I'm not sure whether or not is answerable. I have no problem emailing a copy of my userform's text boxes and combo boxes. The issue I am having is when it comes to check boxes. Is it possible to do one of the two following things in regards to emailing?

A) Have the label of a checkbox copied into email if the box is checked?

or

B) If I type the label name in the email coding, is it possible to have yes or no displayed based on whether or not the checkbox is checked?

If either one is possible, could you provide the coding assuming the checkboxes are named box1, box2, etc.?

Thank you!

Hi Leith,

Thank you for the response. Would you happen to have the coding I could use so checkbo=checked displays "yes"? I haven't put the code together yet for this form which is why I can't post a copy of the code for you.

I have nothing in the workbook yet, I am still just working on the coding. Here is what I have so far if it helps:

Please Login or Register  to view this content.

Thankyou Tinbendr, you pointed me the way I needed. This was what I ended up with

If Printhost.Value = True Then
sMsgBody = sMsgBody & Printhost.Caption & vbCr & vbCr
End If