excel formula

[remco]

Version: Older version Processor: Intel How can I display cell comments from my master worksheet sheet1 cell A1 onto other worksheets in the same workbook

 

[CyberTaz]

A Comment is attached to a specific cell & only displays on the sheet which
contains that cell. Whether something could be done with VBA I don't know.

It's difficult to offer anything more because "Older Version" is
insufficient information. You need to specify exactly what version of Excel
you're using as well as its specific update level. It would also be helpful
if you'd include what version of the Mac OS you're running it on. However...

This question has *nothing* to do with the thread to which you posted as a
REPLY. If you need any further information please post a NEW message & state
all particulars as suggested above as well as complete details pertaining to
what you want to accomplish. There may be other options available.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[JE McGimpsey]

Version: Older version
Processor: Intel

How can I display cell comments from my master worksheet sheet1 cell A1 onto
other worksheets in the same workbook

One way (using a User Defined Function):

Public Function RefComment(ByRef rng As Range) As String
Dim sReturn As String
sReturn = ""
On Error Resume Next
sReturn = rng(1).Comment.Text
On Error GoTo 0
RefComment = sReturn
End Function


Usage:

=RefComment(Sheet1!A1)