vba to make a checkbox return Yes or No

**jpruffle** · 04-27-2009, 09:31 AM

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** · 04-27-2009, 09:34 AM

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

Private Sub CheckBox1_Click()
    Range("A1") = IIf(CheckBox1.Value, "Yes", "no")
End Sub

**jpruffle** · 04-29-2009, 04:48 AM

Hi,

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

ws.Range("Pact1ActName").Cells(Me.SelectAct1.ListIndex + 1, 1).Offset(0, 8) = Me.Comp11.Value

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.