ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Conditional Commenting (https://www.excelbanter.com/excel-programming/335245-conditional-commenting.html)

M H

Conditional Commenting
 
Is there any way to perform conditional commenting? I mean when I'm
entering records and moving along the row, a comment will pop up from an
empty cell (say column F) to tell me some instruction, and then it
disappears after completing the record. It shows up again when coming
to the same column of the next row.

*** Sent via Developersdex http://www.developersdex.com ***

paul

Conditional Commenting
 
data validation,select cell you want to show comment,select
datavalidation,depending on exact requirements restrict entry on settings
tab or click straight throught to input message tab.Make sure that "show
input message when cell is selected" checkbox is ticked then fill in the
textbox for the "comment" you want.
--
paul
remove nospam for email addy!



"M H" wrote:

Is there any way to perform conditional commenting? I mean when I'm
entering records and moving along the row, a comment will pop up from an
empty cell (say column F) to tell me some instruction, and then it
disappears after completing the record. It shows up again when coming
to the same column of the next row.

*** Sent via Developersdex http://www.developersdex.com ***


M H

Conditional Commenting
 
Much thanks, Paul.



*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT +1. The time now is 11:36 PM.

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