Count number of clicks

[MarkCBB]

Hi there,

I am looking for some code that can record the count of clicks for example
If I select C2, then A1 = 1 then if a select b23, then A1 = 2

so for each selection the value of A1 increase by 1

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A1").Value = Range("A1").Value + 1
End Sub

 

[MarkCBB]

Hi Vog,

is there away to do this by selection as well, meaning if I select a chart, picture, shape?

 

[VoG]

Sorry, I don't know any straightforward way (without assigning code to each object).

 

[MarkCBB]

no worries, I will give it a bash. thanks for your help once again, you have been very helpfull on my posts. thanks VoG

 

[boostin06evo]

Noticed this and thought I'd try my first use of VBA.

I need to learn this stuff. Very useful indeed.

Thanks!