hi,

i have a situation where i am trying to get input from the user on the number of days to add to "something". The user can input a "0"...zero...as a possible anser. The problem is this.

I look at the value input by the user to determine if the user hit the cancel button. This i believe evaluates to False or something. My problem is that if the user hits cancel or inputs a ZERO .......they both get evaluated the same. Below is the code i am using.

Any ideas?

    lag_input = Application.InputBox(Prompt:="Please enter in DAYS the expected data flow / cleaning lag.", _
            Title:="Enter the expected data flow / cleaning lag in DAYS", Type:=1)


    Application.ScreenUpdating = False
    
    On Error GoTo 0
    
    Application.DisplayAlerts = True

    'user hit cancel...then dont save
    If lag_input = "" Or lag_input = False Then
        end_pgrm = True
        Exit Sub
    End If