Excel 2007 : Auto detect cell selection

[Obfuscated]

Hi everyone,

I'm trying to detect when a cell is selected. If cell A1 is selected and the user selects cell B5 (just a simple mouse click) but doesn't enter anything, can I detect that B5 was selected?

Thanks.

[MarMo]

Hi,
You could use VBA code on the Worksheet SelectionChange event.
Copy this simple code in the VBA editor in sheet 1 ; and then click a cell.
Msgbox will appear with the selected cell's address.

Please Login or Register  to view this content.

[Obfuscated]

Thanks, That works great. I was under the misconception that the contents of the cell had to be changed before this would work.