Hello all,
So I have two macros. I want the first one to run if the value in cell A5 is between 101-125 (including 101 and 125). I want the second macro to run if A5 is 0. But, if a number other than 0 or 101-125 is entered, I would like an error message to pop up. I have found I cannot use data validation because it prevents the usage of the number zero.

I've been using the following code in the sheet code but it simply is not setup for the value range of 101-125 and I can't figure out how to get it to work:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("A5")) Is Nothing Then
Select Case Target
        Case Is < 1
            Call Macro3
            
        Case Is > 1
            Call Macro1
            
        End Select
    End If
End Sub
-All advice is appreciated,
Aarzu Maknojia