vba to make a checkbox return Yes or No

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.

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.