Message Or Macro According To The Value İn The Cell Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Private Sub Worksheet_Calculate() Worksheet_Change Range("VB_Trigger") End Sub Private Sub Worksheet_Change(ByVal Target As Excel.Range) ' Level 1: Set up the event to watch a single cell. If Target.Address = Range("VB_Trigger").Address Then ' Level 2: Perform some action based on the value of the watched cell. Select Case Target.Value Case 1 MsgBox "Hello" Case 2 MsgBox "Goodbye" Case 3 MsgBox "Pretty Bird" End Select End If End Sub Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 message or macro according to the value in the cell 2 excel operators hk 3 find and list them in a message 4 Write numbers to a1: a5 and warns c1 if their total is 100 5 Write numbers to a1: a5 and give warnings to c1 if their sum is not 100 6 status bar macro with a message waiting 7 a1: a10 collect message send total to a11 8 entering formula with message box 9 change the message text written in macro 10 receive a message with a macro 11 Undo cells with 0 12 macro running according to condition 13 auto macro recording 14 a macro that gives information to different cells based on the given value 15 100 messages with the selected cell 16 Color the cell according to the words written in it 17 cells are filled with colors according to the values of the cell 18 cells fill in colors according to the cells values on your worksheet 19 time format in active sheet / page and target cells 20 excelin all menu pushbutton pictures