I NEED A FORMULA IN EXCEL?

Solved/Closed
Mafrin - Dec 5, 2009 at 01:03 AM
 Mafrin - Dec 7, 2009 at 09:01 AM
Hello,

Hello...
I have a cell A1 that show $200.00. now if am type $ 200.00 in B2 automatically A1 cell amount should show as 0
your help much appriciated

Mafrin

1 reply

Hi Mafrin,

Right click on sheet tab > View code and insert this code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("B2") = "$200.00" Then Range("A1") = "0"
End Sub


Best regards,
Trowa
1
Hello Trowa,

Its Great!!!

but i don't know how to run that code in work sheet. please advice

Best regards
Mafrin
0