How to record Click by cell coordinate?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • LyTseu
    New Member
    • Aug 2010
    • 14

    How to record Click by cell coordinate?

    Hello All,

    I'm actually working on a project using Excel, I wanted to record in one part of my excel book where I clicked in the excel sheet. Let me explain a little bit
    Pretty much I have a picture set in the background, and if a user click on a cell (e.g A1, f2 etc..) it will populate for an example in the bottom rows (e.g row 30 to 40) that I clicked once or twice in cell A1 or etc.. kinda like filling up a table where which cell I cliked in so far.

    So far what I did is I but invisible labels in some cells and use an increment of +1 to record the different click, but as you can imagine that means a lot of invisible label or formulas...

    If anyone could help that would be great.
    Thank you!
Working...