ExcelTips (Menu Interface)
Members
This Site
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our site focusing on the ribbon interface.
Helpful Links
ExcelTips FAQ
Ask an Excel Question
Make a Comment
Free Business Forms
Free Calendars
Subscribe
Conditionally Displaying a Message Box
Summary: If you want to display a message box when a particular set of criteria are met, you'll be interested in the techniques in this tip. The approach discussed here relies on the use of the Change event for a worksheet. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)You may have a need to display a message box whenever specific information is placed in a specific cell by the user. Fortunately, using the Change event for a worksheet can help you to figure out when something has been placed in a cell.
For instance, let's say that you wanted to displays a message whenever the information in cell C3 is changed. The following, added to the code window for a specific worksheet, will do the trick:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$3" Then
MsgBox "Changed It!"
End If
End Sub
The Change event is called, and passes the cell range to the routine. In this case, the range is assigned to the Target variable. The address of this range is then checked, and if it is equal to C3, (has to be noted in absolute terms, such as $C$3), then the message box is displayed.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2553) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Related Tips:
Save Time and Money! Many people need to keep track of employee time, but don't know where to start when it comes to creating a spreadsheet. Here's a way to save time, effort, and money with ready-to-use timesheet templates. Check out Timesheet Templates today!