Hi D & C,

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox "You selected cell " & ActiveCell.Address
End Sub

HTH
Regards,
Howard

"DianeandChipps" wrote in message
...
I added a message to show on screen when any of the cells in one column was
clicked on. I would like to do this again but can't remember how I did
it.
Can anyone help? Many thanks