Comment instead of Data Validation

G

Guest

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

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top