Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 24th 06, 06:52 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 7
Default Copying comments from one cell to another, in a different spreadsheet

Hello Friends,

I would like to be able to write a comment in a cell, then have that
comment appear in another cell on a different spreadsheet within the
same workbook, though. Or within the same spreadsheet.

Is there a formula or some sort of formatting to allow for the type of
function?


Thanks in advance!!


  #2   Report Post  
Old July 24th 06, 07:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 644
Default Copying comments from one cell to another, in a different spreadsheet

I'm not sure if it can be done without code. Insert this in a new
module in "Personal.xls" in the VBA editor. Let me know if you need
further explanation or if you want to tie it directly to your workbook.

Function Comments(iRange As Range) As String
If iRange.Comment Is Nothing Then
Comments = "NA"
Else
Comments = iRange.Comment.Text
End If
End Function

then in your spreadsheet type
=Comments(A1)

HTH


Die_Another_Day
=!CmOrE!= wrote:
Hello Friends,

I would like to be able to write a comment in a cell, then have that
comment appear in another cell on a different spreadsheet within the
same workbook, though. Or within the same spreadsheet.

Is there a formula or some sort of formatting to allow for the type of
function?


Thanks in advance!!


  #3   Report Post  
Old July 24th 06, 08:55 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27
Default Copying comments from one cell to another, in a different spreadsheet

you can use "copy" on cell with comment and "Edit"-"Paste Special"-"Comment"
on cell which should receive comment.

"=!CmOrE!=" wrote in message
oups.com...
Hello Friends,

I would like to be able to write a comment in a cell, then have that
comment appear in another cell on a different spreadsheet within the
same workbook, though. Or within the same spreadsheet.

Is there a formula or some sort of formatting to allow for the type of
function?


Thanks in advance!!



  #4   Report Post  
Old July 24th 06, 09:11 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 7
Default Copying comments from one cell to another, in a different spreadsheet

Couldn't do it. Can you explain further.

Thank you
Die_Another_Day wrote:
I'm not sure if it can be done without code. Insert this in a new
module in "Personal.xls" in the VBA editor. Let me know if you need
further explanation or if you want to tie it directly to your workbook.

Function Comments(iRange As Range) As String
If iRange.Comment Is Nothing Then
Comments = "NA"
Else
Comments = iRange.Comment.Text
End If
End Function

then in your spreadsheet type
=Comments(A1)

HTH


Die_Another_Day
=!CmOrE!= wrote:
Hello Friends,

I would like to be able to write a comment in a cell, then have that
comment appear in another cell on a different spreadsheet within the
same workbook, though. Or within the same spreadsheet.

Is there a formula or some sort of formatting to allow for the type of
function?


Thanks in advance!!


  #5   Report Post  
Old July 25th 06, 01:39 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 644
Default Copying comments from one cell to another, in a different spreadsheet

To make the code stay with your workbook.
Open the workbook.
Press Alt+F11
Click the Insert menu
Click Module
Copy the following code into the page that opens

Function Comments(iRange As Range) As String
If iRange.Comment Is Nothing Then
Comments = "NA"
Else
Comments = iRange.Comment.Text
End If
End Function

That should do it

Die_Another_Day

=!CmOrE!= wrote:
Couldn't do it. Can you explain further.

Thank you
Die_Another_Day wrote:
I'm not sure if it can be done without code. Insert this in a new
module in "Personal.xls" in the VBA editor. Let me know if you need
further explanation or if you want to tie it directly to your workbook.

Function Comments(iRange As Range) As String
If iRange.Comment Is Nothing Then
Comments = "NA"
Else
Comments = iRange.Comment.Text
End If
End Function

then in your spreadsheet type
=Comments(A1)

HTH


Die_Another_Day
=!CmOrE!= wrote:
Hello Friends,

I would like to be able to write a comment in a cell, then have that
comment appear in another cell on a different spreadsheet within the
same workbook, though. Or within the same spreadsheet.

Is there a formula or some sort of formatting to allow for the type of
function?


Thanks in advance!!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying cell names Al Excel Discussion (Misc queries) 12 August 11th 05 03:01 PM
Paste Link - Cell Comments get lost Wayne H Excel Worksheet Functions 2 February 27th 05 12:51 AM
How do I export comments into another excel column as cell content Hernan Excel Worksheet Functions 1 February 25th 05 03:17 PM
how do I reference a spreadsheet in a cell Lee_Wrede Excel Worksheet Functions 2 February 25th 05 03:11 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017