Excel comments - possible with relative cell reference?

  • Thread starter Thread starter u539771
  • Start date Start date
U

u539771

Does anyone know how to make a cell comment stay with that cell, eve
when new rows are inserted above it, i.e. make it a relative, rathe
than the default absolute position?

Cheers all.

Mar
 
Hi Mark,
I am not familiar with cell comments not staying with the cell that they
are in. Are you really talking about cell comments with the red triangle
indicators or is it something else..
http://www.mvps.org/dmcritchie/excel/ccomment.htm

Perhaps you are talking about TextBoxes which float over the worksheet
but can be locked to a specific cell..
 
I think the OP's talking about having a comment in cell C5 remain in
cell C5 if a row is inserted above it - sort of an =INDIRECT("C5")
analogue.

I can't think of any way to do it on a general basis. Could probably be
done with an event macro or an OnTime macro as a one-off.
 
Hmmm, a bit dangerous unless there is only one comment cell in the
sheet. You could name that cell, and then use an event macro
possibly triggered on sheet activation,
to copy the comment from the named cell and put it into cell C5
get rid of the named cell name and assign it to C5. But I think it
would cause too much interference to be of any use.

And since this is the worksheet.functions page, I don't think they
want to introduce a macro that is going to cause problems, so
not much point is coding an example, unless someone comes up
with something more direct.
 
Thanks for trying guys. Yes, it is the comment with the red triangl
that I'm referring to, but I definitely don't want to get in to V
macros to do it! I just wanted a way of drawing the viewers attentio
to the fact that there is a note relevant to the figure shown in tha
cell, without them having to move the mouse over it before they saw
comment. That worked fine, until I realised that as I inserted a ro
those comments each day, the red triangles stayed on the same ro
numbers, and didn't move down with the data they referred to.

I guess it's just back to the drawing board!

Cheers

Mar
 
u539771 > said:
.. I just wanted a way of drawing the viewers attention
to the fact that there is a note relevant to the figure shown in that
cell ..
Click to expand...

One "in-cell" option to play around with,
instead of using comment boxes ..

Put in say, A1: = 5 + N("Explanatory text for A1's value")

Repeat above construct with different values / text in A2 and A3

In A4: =SUM(A1:A3)
will work as per normal returning the total
 
Back
Top