Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get comment from excel?
I use Comment.Text to get it,it show 800A01B6.
I can use Comment.Author to get right value. Is the method wrong? how can I get comment from excel? thx! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get comment from excel?
Sub commment()
Dim c As Comment Set c = Range("C8").Comment MsgBox (c.Text) End Sub -- Gary''s Student - gsnu200856 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get comment from excel?
Range("A1").Comment.Text
here's a demo that takes the comment and places it into the next cell to the right Option Explicit Sub GetComment() Dim cellall As Range Dim cell As Range Dim addr As String Set cellall = ActiveSheet.Cells.SpecialCells(xlCellTypeComments) If Not cellall Is Nothing Then For Each cell In cellall.Cells addr = cell.Address cell.Offset(, 1) = cell.Comment.Text Next End If End Sub "zq1956" wrote in message ... I use Comment.Text to get it,it show 800A01B6. I can use Comment.Author to get right value. Is the method wrong? how can I get comment from excel? thx! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show Excel comment on mouseover but not the comment indicator | Excel Programming | |||
How do I remove the red corner in excel comment and keep comment? | Excel Programming | |||
Excel Comment Box | Excel Discussion (Misc queries) | |||
How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) | |||
a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions |