help on a formula

[Guest]

hello all, i have a database with all my invoices and their dollar totals in
column b.what i want to do is if in colunm a1 i enter the word open then the
corresponding invoice total b1 will be $00.00.any help will be
appreciated.thanks wyn

 

[Guest]

Hi WYN,

Apply this event macro:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 And Target.Value = "open" Then
Range("B" & Target.Row).Value = 0
Range("B" & Target.Row).NumberFormat = "[$$-409]##,#00.00"
End If
End Sub

Post if you need help to install it!

Regards,
Stefi

„WYN†ezt írta:

 

[Guest]

hi stefi, thank you, that works just fine. wyn.
--
wynb

Hi WYN,

Apply this event macro:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 And Target.Value = "open" Then
Range("B" & Target.Row).Value = 0
Range("B" & Target.Row).NumberFormat = "[$$-409]##,#00.00"
End If
End Sub

Post if you need help to install it!

Regards,
Stefi

„WYN†ezt írta:

hello all, i have a database with all my invoices and their dollar totals in
column b.what i want to do is if in colunm a1 i enter the word open then the
corresponding invoice total b1 will be $00.00.any help will be
appreciated.thanks wyn

 

[Guest]

You are welcome! Thanks for the feedback!
Stefi


„WYN†ezt írta:

hi stefi, thank you, that works just fine. wyn.
--
wynb

Hi WYN,

Apply this event macro:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 And Target.Value = "open" Then
Range("B" & Target.Row).Value = 0
Range("B" & Target.Row).NumberFormat = "[$$-409]##,#00.00"
End If
End Sub

Post if you need help to install it!

Regards,
Stefi

„WYN†ezt írta:

hello all, i have a database with all my invoices and their dollar totals in
column b.what i want to do is if in colunm a1 i enter the word open then the
corresponding invoice total b1 will be $00.00.any help will be
appreciated.thanks wyn