Hi,manuel
Perhaps something like this:-
If you have a cell (Say "A1") with Text in it "Hamburg" and you click that cell, then a cell relating to "Hamburg", the "Hamburg count cell" (in this case "A2") increases its value by 1, each time you click off it, and then click it again another 1 is added.
Alter the code by adding "Cases" and changing the "Count cells" addresses to suit you sheet.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Select Case Target
Case "Hamburg"
Range("A2") = Range("A2") + 1
Case "London"
Range("B2") = Range("B2") + 1
Case "Paris"
Range("C2") = Range("C2") + 1
Case "Berlin"
Range("D2") = Range("D2") + 1
End Select
End Sub
Regards Mick
Bookmarks