Insert a File, not a Comment, to a Cell

[Curious]

I am wondering if Excel allows a file (text file, or HTML file) to be
inserted to a cell. I know I can insert a comment. But I want to
attach a very long email chain to a cell, comment isn't quite
readable.

Thanks in advance.

H.Z.

 

[Sean Timmons]

You mean a link to a file?

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"full path", TextToDisplay:= "Click Here"

 

[Curious]

You mean a link to a file?

    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
        "full path", TextToDisplay:= "Click Here"

Thank you for the quick response. I know the hyperlink will activate
(lead me to) a worksheet. I just want to know if I can insert or hide
a file to a cell like a comment. That means, I imagine, I can click
the cell and see the content of the file.

 

[Normek]

You could use a TextBox in a UserForm and activate with something like:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then
UserForm1.Show
End If
End Sub