Option Button Question

[dualhcsniatpac]

Is there anyway to get an option box to return a number value instead of a true/false value. When I send it to my spreadsheet it keeps coming up as true/false and I want it to be either a 0 for false or 1 for true.

Here is the code I have now:

        If tacknone.Value = True Then
            tacknone.Value = 1
        Else
            tacknone.Value = 0
        End If
        ActiveCell.Offset(0, 7) = tacknone.Value
        
        If tack1.Value = True Then
            tack1.Value = 1
        Else
            tack1.Value = 0
        End If
        ActiveCell.Offset(0, 8) = tack1.Value
        
        If tack2.Value = True Then
            tack2.Value = 1
        Else
            tack2.Value = 0
        End If
        ActiveCell.Offset(0, 9) = tack2.Value
        
        If tack3.Value = True Then
            tack3.Value = 1
        Else
            tack3.Value = 0
        End If
        ActiveCell.Offset(0, 10) = tack3.Value
        
        If tack4.Value = True Then
            tack4.Value = 1
        Else
            tack4.Value = 0
        End If
        ActiveCell.Offset(0, 11) = tack4.Value

The option buttons are in a frame so only 1 is being checked at a time.

Thanks for the help.

 

[Trebor76]

Hi dualhcsniatpac,

As the option box value is a boolean type it will return true/false based on whether a 1 or a 0 (respectively) is assigned to it. To return the numeric equivalent (or any value for that matter) of true or false use the following example for each option box:

If tacknone.Value = True Then
        ActiveCell.Offset(0, 7).Value = 1
    Else
        ActiveCell.Offset(0, 7).Value = 0
    End If

HTH

Robert

 

[dualhcsniatpac]

Awesome that makes sense. Thanks!

 

[Trebor76]

You're welcome :wink: