Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text from a comment box into a cell
Hi, is there any solution to extract the text written in a comment box to a
specific cell I tried the following but this message #name? appeared Select the cell which has the comment Go to InsertName (Define Name in formulas tap) a window will appear Now insert the following formula in the "Refers to" box - get.object(12,"comment 1") and give it a name, say trial In any cell (say A5) where you want to insert the contents of the comments box, say =trial. Please check where is my mistake, note that I have Office 2007. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text from a comment box into a cell
A macro might be an easier solution.
This one line will do it for you: ActiveCell.Formula = Range("E7").Comment.Text On May 6, 3:26*pm, MFS wrote: Hi, is there any solution to extract the text written in a comment box to a specific cell I tried the following but this message #name? appeared Select the cell which has the comment Go to InsertName (Define Name in formulas tap) a window will appear Now insert the following formula in the "Refers to" box - get.object(12,"comment 1") and give it a name, say trial In any cell (say A5) where you want to insert the contents of the comments box, say =trial. Please check where is my mistake, note that I have Office 2007. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text from a comment box into a cell
Hi,
I replicated the steps and it worked as expected - no error -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "MFS" wrote in message ... Hi, is there any solution to extract the text written in a comment box to a specific cell I tried the following but this message #name? appeared Select the cell which has the comment Go to InsertName (Define Name in formulas tap) a window will appear Now insert the following formula in the "Refers to" box - get.object(12,"comment 1") and give it a name, say trial In any cell (say A5) where you want to insert the contents of the comments box, say =trial. Please check where is my mistake, note that I have Office 2007. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move Comment into cell as Text | Excel Discussion (Misc queries) | |||
Move comment into cell as text | Excel Discussion (Misc queries) | |||
How can I link the text in a cell into a comment box? | Excel Discussion (Misc queries) | |||
Create Cell Comment based on text in a cell on another worksheet | Excel Discussion (Misc queries) | |||
How do I copy text from a cell into a comment? | Excel Discussion (Misc queries) |