Help with check box

[HDfatboy03]

Hello

Need help with check boxes. I have the following statement, the check box return's "TRUE" when selected but does not return "FALSE" when NOT selected and I need it turn return "FALSE" when not selected.

Below is the code I am using. What am I missing?

<Start Code>

'START box buttons for FAIRWAYS HIT H E R E
'copy the NEW DATA FAIRWAYS HIT to database
If FH1 = True Then
ws.Cells(iRow, 42).Value = FH1.Value
ws2.Cells(9, "C").Value = FH1.Value
End If

<End Code>

Thanks for any assistance or suggestion

HDfatboy03

 

[jim may]

How did you create your Checkboxes? Using Forms Toolbar or Active-X toolbox?

 

[dave3009]

Perhaps

'START box buttons for FAIRWAYS HIT H E R E
'copy the NEW DATA FAIRWAYS HIT to database
Select Case FH1
Case True:  ws.Cells(iRow, 42).Value = FH1.Value
            ws2.Cells(9, "C").Value = FH1.Value
Case False:
End Select

 

[AlphaFrog]

Take out the IF function...

'START box buttons for FAIRWAYS HIT H E R E
'copy the NEW DATA FAIRWAYS HIT to database
ws.Cells(iRow, 42).Value = FH1.Value
ws2.Cells(9, "C").Value = FH1.Value

 

[HDfatboy03]

Jim

Thanks for the help ... its working now. Now my formula is not working,

=COUNTA(C10:K10)

I need my formula to COUNT the "TRUE" in that range. Do you have any suggestions?

Thanks for your help

HDfatboy03

 

[AlphaFrog]

Maybe try...
=COUNTIF(C10:K10, TRUE)

or

=SUM(C10:K10)

assuming all the cells in C10:K10 are true or false (1 or 0)

 

[HDfatboy03]

Thanks so much ... that works ... you are awesome