Hi, i am new to marco. i need to some help that can make the file prompt up message (when saving the file), lets say cell E10 the total is less than 100.
I tried many online sample but it does not prompt.
i tried following sample online but nothing prompt
Private Sub Worksheet_Change(ByVal Target As Range) If Range("E10").Value > 100 Then MsgBox "Try again total is not 100" End If End Sub
Thank you in advance!!