Previous Topic Next Topic

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 response

Answer 1 / 1
Trowa
Dec 7, 2009 at 08:49 AM
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
Mafrin
Dec 7, 2009 at 09:01 AM
Hello Trowa,

Its Great!!!

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

Best regards
Mafrin
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response