help with VBA conditional notification emails

I am new to VBA coding and I have tried to figure this out but my head is starting to hurt so I thought I would ask for help. I want excel to automatically send an email to multiple recipients when the formula in R26 finds the information that meets the correct criteria and populates with data but not when it goes back to an unpopulated cell. I have found a lot of different codes that send different types of emails but I am having a hard time figuring out what each line does and I am not sure how to adapt it to what I want.

that meets the correct criteria and populates with data but not when it goes back to an unpopulated cell.

Does the macro need to check the data for accuracy prior to sending the email/s ... or, can the email/s be sent anytime the cell has data within ?

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim rngWatch As Range
    Dim OutApp As Object
    Dim OutMail As Object
    
    'What cell do you care about?
    Set rngWatch = Range("R26")      '<-- Change cell to match your requirements
    
    'What's the criteria?
    If rngWatch.Value <> "" Then     '<-- Change value number to match your requirements

        Set OutApp = CreateObject("Outlook.Application")
        Set OutMail = OutApp.CreateItem(0)
    
        On Error Resume Next
        With OutMail
            .to = "YourEmailHere@example.com" '<-- Edit this email address to match your requirements
            .CC = ""
            .BCC = ""
            .Subject = "This is the Subject line"
            .Body = "Number has been reached"
            
            '-- Using .Send auto-emails the message. You do not have an opportunity to review or edit prior to sending
            '--- Using .Display gives you the opportunity to review and edit prior to sending
            '.Send   'or use .Display
            .Display
        End With
        On Error GoTo 0
    
        Set OutMail = Nothing
        Set OutApp = Nothing
    End If
End Sub

Thank you so much for your help. I will try it out the next time I go in to work

alright so I put in the code but nothing happened I tried F5 and ALT+F8 but the option to select it was not there am I missing something?