Hello

I am 3 weeks into learning VBA so knowledge is low.
Still, how do I get VBA to return the cell reference of
an activecell?

If I click on, say, cell B10 how can I get VBA to
register that? The reason is, say I click on cell B10, I
want that to trigger VBA to bring up a MsgBox. But I
can't find a way for VBA to recognise that cell B10 has
been 'clicked upon'!

I just can't find away in which VBA will recognise cell
references.

Suppose, cell B10 has the value 5. If I type...

MsgBox Range("B10").Value

Then I get a MsgBox showing 5. But suppose I wanted VBA
to tell me which cell in a worksheet contained the value
5 (assuming there is only one).

Any thoughts out there?