Well, to get things working as you say, how about this syntax for a Selection event. You did not say what range of cells in the sheet might contain "Click here" or any other words you have in mind, so if you have...
- "Click here"
...as possible trigger values, then try this:
Right click on your sheet tab, left click on View Code, and paste the following procedure into the large white area that is the worksheet module. Press Alt+Q to return to the worksheet.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
Select Case Target.Value
Case "Click here", "Something", "Anything"
"You clicked on cell " & Target.Address(0, 0) & "," & vbCrLf & _
"which contains the value ''" & Target.Value & "''." & vbCrLf & vbCrLf & _
"Whatever else you want to say goes here.", 64, "Information alert !!"
Then, modify the code for actual trigger values, and the prompt text in the message box for whatever you really want to say.