help on a formula

W

WYN

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
 
S

Stefi

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:
 
W

WYN

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


Stefi said:
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
Click to expand...
Click to expand...
 
S

Stefi

You are welcome! Thanks for the feedback!
Stefi


„WYN†ezt írta:
hi stefi, thank you, that works just fine. wyn.
--
wynb


Stefi said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top