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).

--
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

On May 8, 10:36 pm, dee wrote:
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).

--
Thanks!

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


"Pete_UK" wrote:

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

On May 8, 10:36 pm, dee wrote:
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).

--
Thanks!

Dee