Check Box

[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?

 

[Shane Devenshire]

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