Counting total of dropdown

[johnrobgray]

Hi guys

I’m still struggling with this one

I have a sheet that has a column and the cells have a drop down box for selection

I want to put the number of times the drop down is used in a cell as a number, no matter what is selected

So example, if it is chosen 3 times in the cells it would display “3” in a destination cell as a running count. Don’t want to count each individual selection, just the number of times a selection is made

Anyone have any ideas on this one?

Thanks

 

[My Aswer Is This]

Since you gave no details like in what column you will be entering these values and where you want the count put.

This script is assuming you will entering the values in column "H" and the count will be in column "I"

If this is not true modify the portion of the script where it says "H:H"
the results will always go in the next column to the right.

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("H:H")) Is Nothing Then
If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
Target.Offset(, 1).Value = Target.Offset(, 1).Value + 1
End If
End Sub