If you put this in your worksheet's code module, selecting cell A1
will pop up a messagebox

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
Call MsgBox("Here's what's in A1: " & Range("A1").Value)
End If
End Sub

On Nov 1, 12:50 pm, Robbo wrote:
I am creating an excel worksheet whereby I generate a 'single file web page'
to publish onto the internet. I want users to click on a specific cell
whereby it opens up a 'pop up' window that provides data/information relevant
to what is in that cell.

I can of course create the hyperlink but I am having problems in identifying
a way of asking excel to open up a new window to display the information. I
would be extremely grateful if anybody can please guide me in the right
direction.

many thanks