how to get Checkbox value in excel

[syedali]

Hi ,

i am writting a program in excel to send the data by an email. In data entry there are few check boxex and drop down lists.

Send i send email dropdown list value appears in new mailed sheet but not checkbox value.

is their away to solve this problem

Thanks in Advance
Syed

[royUK]

Are the checkboxes on a worksheet? If so what type are you using?

An example workbook would help