open up a pop up window in excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
Back
Top