ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Comment instead of Data Validation (https://www.excelbanter.com/excel-discussion-misc-queries/142016-comment-instead-data-validation.html)

DEE

Comment instead of Data Validation
 
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

Pete_UK

Comment instead of Data Validation
 
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




DEE

Comment instead of Data Validation
 
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






All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com