Cell count
Closed
hockey_pro
Posts
1
Registration date
Thursday June 11, 2009
Status
Member
Last seen
June 13, 2009
-
Jun 13, 2009 at 03:51 PM
venkat1926 - Jun 14, 2009 at 09:08 PM
venkat1926 - Jun 14, 2009 at 09:08 PM
Related:
- Cell count
- Excel count occurrences - Guide
- Count names in excel - Guide
- Cell phone codes - Guide
- Excel cell color formula - Guide
- Based on the cell values in cells b77 ✓ - Excel Forum
1 response
I do not know whether you can enter number in a cell to add to the previous entry. you can do one trick
suppose b1=5
riight click sheet tab and click view code and copy paste this code
now enter any number to A1 and see what happens to B1
again enter another no. in A1 and see what happens B1
post feedback
suppose b1=5
riight click sheet tab and click view code and copy paste this code
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
On Error GoTo line1
If Target.Address <> "a1" Then
Range("b1") = Target + Range("b1")
End If
line1:
Application.EnableEvents = True
End Sub
now enter any number to A1 and see what happens to B1
again enter another no. in A1 and see what happens B1
post feedback
