Click here to bring up message box

[Brigid26]

Hi All

Is there anyway in excel that I can put in a link on say 'click here for more info' and get a message box to pop up?

Thanks in Advance

Brigid

 

[AlphaFrog]

You could add a comment to the cell. (Right-click on the cell and select add comment).

Or...

• Right-click on the sheet tab
• Select View Code from the pop-up menu
• Paste the code below in the VBA edit window
• Change the "A1" in the code to the cell that you want the message box.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Address(0, 0) = "[COLOR="Red"]A1[/COLOR]" Then
        MsgBox "Hello world.", , "My Message Title"
    End If
End Sub

 

[Brigid26]

Thank you very much. Perfect!!