open up a pop up window in excel 2007

[Guest]

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

 

[ilia]

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

 

[Guest]

that was great help thank you.

Lets say for example now that I have a range of cells within my worksheet
that each contain text that I want to hyperlink to various different web
sites etc.

Can you give me any indication on how that would be coded.

Again, many thanks