count row on the click

[andrugrasu]

I have the following situation. In cell A1 if I click on the click, I want the number 1 to appear. If I go to A2 and click on the number 2 to appear, I want to be able to have a count but based on the click.

[maniacb]

so you want the row number to appear when you click on a cell? Would you settle on getting the row number on a double-click?

[andrugrasu]

It doesn't bother me with a double click

[maniacb]

Place this code in your sheet module

Please Login or Register  to view this content.

[andrugrasu]

Place this code in your sheet module

Please Login or Register  to view this content.

I don't think I expressed myself correctly. When I click on cell A1, I want the value 1 to appear in the cell. Not to be displayed in a window.

[Bo_Ry]

Maybe try

Please Login or Register  to view this content.

[andrugrasu]

Maybe try

Please Login or Register  to view this content.

Works. But the value does not remain in the cell after I click, and I want if it can only be done in column A to be able to do this counting.

[Bo_Ry]

Try this

Please Login or Register  to view this content.

[Carim]

Hi,

You could test following

Please Login or Register  to view this content.

[andrugrasu]

thx. you. is working.

[Carim]

You are welcome

Thanks for your Thanks