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
- Conditional formatting if cell contains text - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- An example of a cell is a blank cell ✓ - Programming Forum
- Youtube subscriber count - Guide
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
