Check Box

  • Thread starter Thread starter Kaey
  • Start date Start date
K

Kaey

I have cell I13 which calculates the tax amount of an item. I have now set up
a check box, when it is clicked it will display a user form asking to user to
enter an alternative tax amount and press “OK†button. I have linked the “Okâ€
button’s result to O13.

How do I write the code if I want the O13 result to overwrite I13 only if it
is checked and if it is not checked – I13 calculation will remain?
 
Hi,

You didn't show us any of your code but

Private Sub btnOK_Click()
If Me.chkCondition = True Then
[I13]=[O13]
End If
End Sub

I am assuming your checkbox is named chkCondition

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 
Back
Top