![]() |
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 |
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 |
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