Comment instead of Data Validation

[dee]

I need to add comments to cells - data validation doesn't work because of the
size limitations.

How do I add code to my worksheet (or workbook) to display comments when the
user tabs or clicks into the cell (as opposed to pointing to the comment).

 

[Pete_UK]

Data Validation allows you to set up an Input message when you land on
the cell - you don't have to set up any constraints to the values (or
by "size" are you referring to the size of the message?)

Pete

 

[dee]

Hi,

No validation input message doesn't work, as there are limits to the size of
both the message box and the actual message.

Comments that are displayed when clicking or tabbing to a cell is what I'm
looking for.

So, I basically need to understand how to add code, I guess, to say "show
comments on active cell"

Thanks!
--
Thanks!

Dee

Data Validation allows you to set up an Input message when you land on
the cell - you don't have to set up any constraints to the values (or
by "size" are you referring to the size of the message?)

Pete