Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Excel Comment to Sheet, Cell (Bookmark)
I would like to be able to view/link the multi-line contents of a cell
on a secondary workbook sheet into the comment of a cell on my primary sheet. I'm trying to avoid re-typing into the comment & I do not want to hyperlink to the sheet as this causes the annoyance of hyperlinking back and forth. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Excel Comment to Sheet, Cell (Bookmark)
Sub Comment_Text()
Dim cmt As Comment Set cmt = ActiveCell.Comment If cmt Is Nothing Then Set cmt = ActiveCell.AddComment cmt.Text Text:=Sheets("Sheet1").Range("A1").Value Else Exit Sub End If With cmt.Shape.TextFrame .Characters.Font.Bold = False End With End Sub Gord On Wed, 3 Sep 2008 09:23:34 -0700 (PDT), Pooh wrote: I would like to be able to view/link the multi-line contents of a cell on a secondary workbook sheet into the comment of a cell on my primary sheet. I'm trying to avoid re-typing into the comment & I do not want to hyperlink to the sheet as this causes the annoyance of hyperlinking back and forth. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I link the text in a cell into a comment box? | Excel Discussion (Misc queries) | |||
Excel formula using bookmark name: create click-link | Excel Worksheet Functions | |||
Comment marker in an Excel sheet cell. | Excel Discussion (Misc queries) | |||
Question: Is it possible to link a cell to a comment box window? | Excel Discussion (Misc queries) | |||
Excel, in a cell, how do i link to a pic & autohide like a comment | Excel Discussion (Misc queries) |