Check Box
 

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€�
buttons 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?

Check Box
 

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

"Kaey" wrote:

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€�
buttons 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?