Good evening,

I would like to create a table in Excel, for simplicity, let’s say 4x4. The table could occupy cells D4:G8. The cells would be numbered 1 thru 16. What I am trying to accomplish is using VBA whenever any of the cells are selected the selected number would appear in another cell, let’s say A2, just like it appears in the formula bar. This may not be far too difficult to solve because no one has been able to code it and I must confess that don't have a clue where to start.

Anyway, thanks for anyone’s help to try and solve the code.

noway