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

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

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



"ilia" wrote:

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