Hi Alvin,
Try something like:
'-----------------------------------------
Public myVariable As String

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
myVariable = "ON"
Else
myVariable = "OFF"
End If
End Sub
'-------------------------------------------

Regards,
Sebastien
"Alvin Hansen" wrote:

Hi

How can i make a value when my checkbox is "on"
and another value when it is "off"

Regards
alvin