+ Reply to Thread
Results 1 to 2 of 2

A cell that counts the number of times...

  1. #1
    Registered User
    Join Date

    A cell that counts the number of times...


    I'm trying to create a formula for a cell on a worksheet that automatically counts the number of times a value (ANY VALUE) in a particular cell has been entered. Is this possible?

    SO basically,..if ANYTHING is entered into this one cell,..it triggers this other cell to count that as 1. It tells me that the cell was populated.

    I'm a newbie in Excel, so any help is greatly appreciated.

    Last edited by TPD; 02-14-2005 at 03:37 PM.
    Todd P. Dolce

  2. #2
    Registered User
    Join Date
    Serbia & Montenegro
    Try with this code:

    Private Sub Worksheet_Change(ByVal Target As Excel.Range)

    If Target.Column = 1 And Target.Row = 1 Then 'observed cell is (1,1) - A1

    Cells(1, 5) = Cells(1, 5).Value + 1 'Counter is in cell (1,5) - E1

    End If

    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1