vba to make a checkbox return Yes or No

[jpruffle]

Hi,

I have created a userform with a check box which when selected returns either "TRUE" or "FALSE". I need it to return Yes or No.

Is there a way to do this please?

Thanks in advance.

[mikerickson]

Where do you want this "Yes"/"No" returned?
If you want it returned to a cell, code like this should work

Please Login or Register  to view this content.

[jpruffle]

Hi,

Thank you for the reply. The checkbox already has code attached to it:

Please Login or Register  to view this content.

In order to return a value onto a range within a sheet.

Is there a way to add your code to it? I'm new to vba and can't work it out?

Thanks in advance.