How Do You Use Data Validation To Create A Pop-Up Message In Microsoft Excel?
You can add a comment to an Excel cell, however, since there are different ways to display comments, it’s possible they may never be seen. This tip shows you how to use Data Validation in Microsoft Excel to add a pop-up message that gets noticed when it needs to be seen. (You can click the images in this article to enlarge them.) Open Excel and the workbook in which you need to insert a comment that won’t get missed. The following directions are for Excel 2007 with steps for Excel 2003 in brackets if different. Click in the cell in which you want to display a pop-up message. In this example, cell C2 is where we will insert a message that will display when the user clicks that cell. Click on Data in the toolbar, then the down arrow of Data Validation, and then Data Validation. [Excel 2003: Click Data, and then Data Validation.] The Data Validation dialog box will display. Click the Input Message tab of the Data Validation dialog box. On the Input Message tab, leave the box checked for “
