+ Reply to Thread
Results 1 to 2 of 2

A cell that counts the number of times...

  1. 02-14-2005, 03:24 PM #1
    TPD
    TPD is offline
    Registered User
    Join Date
    12-10-2003
    Posts
    41

    A cell that counts the number of times...

    Hello,

    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.

    TD
    Last edited by TPD; 02-14-2005 at 03:37 PM.
    Todd P. Dolce
    Reply With QuoteRegister To Reply
  2. 02-14-2005, 11:31 PM #2
    Casper
    Casper is offline
    Registered User
    Join Date
    11-11-2004
    Location
    Serbia & Montenegro
    Posts
    6
    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1