Another. Right click sheet tabview codeinsert this
Private Sub Worksheet_Change(ByVal target As Excel.Range)
If target.Address < "$B$3" Then exit sub
Application.EnableEvents = False
[c3] = target.Value + [c3]
Application.EnableEvents = True
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"fryguy" wrote in message
...
how can i make an event macro to update the value in C3 when a new value
is
entered in B3 without the need to click an update button.
thanks,
fryguy.