help on a formula
 

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
--
wynb

help on a formula
 

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
--
wynb

help on a formula
 

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


"Stefi" wrote:

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
--
wynb

help on a formula
 

You are welcome! Thanks for the feedback!
Stefi


€žWYN€� ezt Ã*rta:

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


"Stefi" wrote:

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
--
wynb