Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get an automatic reminder with a certain cell value?
Is there a way to receive a pop-up comment or text box when a certain thing
is typed into a cell? For example, each time I type "new instrument", I want a reminder to pop-up like a comment would that says "Call Property Accounting". Is there a function like this in Excel? |
#2
|
|||
|
|||
Assuming data entry cells are col. A, right-click the
worksheet tab, choose "View Code", copy in the code below, and press ALT+Q to close VBE. Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim sMsg As String With Target If .Column 1 Then Exit Sub If .Count 1 Then Exit Sub Application.ScreenUpdating = False Select Case LCase(.Value) Case "new instrument" sMsg = "Call Propertry Accounting" Case "new house" sMsg = "Call Inspector" Case "new car" sMsg = "Buy Insurance" Case "robbed" sMsg = "Buy Gun" 'additional messages here Case Else sMsg = "Don't Recognize This" End Select MsgBox sMsg Application.ScreenUpdating = True End With End Sub --- HTH Jason Atlanta, GA -----Original Message----- Is there a way to receive a pop-up comment or text box when a certain thing is typed into a cell? For example, each time I type "new instrument", I want a reminder to pop-up like a comment would that says "Call Property Accounting". Is there a function like this in Excel? . |
#3
|
|||
|
|||
Another site I found:
http://www.totaltesting.com/home/mso.shtml HTH Jason Atlanta, GA -----Original Message----- Is there a way to receive a pop-up comment or text box when a certain thing is typed into a cell? For example, each time I type "new instrument", I want a reminder to pop-up like a comment would that says "Call Property Accounting". Is there a function like this in Excel? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off automatic date formatting? | Excel Discussion (Misc queries) | |||
How do I switch off automatic formatting (e.g. dates)? | Excel Discussion (Misc queries) | |||
Automatic backup copy | Charts and Charting in Excel | |||
How do I get an automatic reminder with a certain cell value? | Excel Discussion (Misc queries) | |||
how do you turn off automatic hyperlink in excel 2003 | Excel Discussion (Misc queries) |