Thread: Formula question??

The one worksheet_change event has a trap to re-enable events if an error occurs. I had remmed out that line when testing and forgot to unrem it. Try this version of the change_event Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target If Application.IsNumber(.Value) Then 'checks for text .Value = .Value +...

Gord: Great- I got it to work! One more question and this will be over. If an error comes up(due to a mistake on my part) it seems that the event stops working. How do I restart it? I understand your concern about having an accumulator of this size. This is one of those situations where this fits my purpose perfectly. This application use fairly small numbers and is not that critical- a small mistake here or there just won't end the...

Here you go http://www.mvps.org/dmcritchie/excel/install.htm -- Regards, Peo Sjoblom "Brad Grow" > wrote in message ... > OK. This is great- it can be done! > > Pretty new at this so what do I do with this code? Copy and paste > somewhere? > > Thanks! > > "Peo Sjoblom" wrote: > >> At the bottom there is a formula solution...

I need to know if there is a way to create a formula that will allow me to enter multiple values in a cell at different times and this formula will sum there values. Example: I would enter 10 in cell B3. An hour later I might enter 25 also in cell B3. After the second entry I would want it to automaticaly display 35. Is this possible and how would it be done? Thanks for your help.