How do I get Excel to do a tally mark total?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have Excel setup so I can enter a number into F3 that would
be added
to a total in B3...then have the number that was enetered in F3 deleted,
thus leaving
F3 blank and ready for a new entry.

Is this possible and how do I set it up?
 
Right click on the Sheet Tab and select View Code. Paste in this code in the
resulting module.

Private Sub Worksheet_Change(ByVal Target As Range)
if Target.Address = "$F$3" then
if not isempty(Target) then
range("B3").Value = Range("B3").Value + Range("F3").Value
Range("F3").Clearcontents
end if
End if
End Sub
 
Extended tally mark question

Is there a way to set excel to use the VBA script for more than once? For example the previous senario was if you entered numbers in F3 it would accumulate in B3 and delete in F3. Is it possible to enter a number in F4 and accumulate in B4 and so on and so on in the same script.
 
tkasual said:
Is there a way to set excel to use the VBA script for more than once? For example the previous senario was if you entered numbers in F3 it would accumulate in B3 and delete in F3. Is it possible to enter a number in F4 and accumulate in B4 and so on and so on in the same script.
Click to expand...

Hi I just stumbled across this post and it is exactly what I need! Does anyone have the last answer? I need this to work in multiple cells...Entering data in F2-F7 and having the running "score", if you will, in B2-B7.

Thank you!
 
Back
Top