Input Box Cancel, Pulling my Hair Out

[cicconmr]

    Dim mcSide As Variant
    Dim mcCellSide As Variant
    Dim mcNewLimit As Variant
    
    mcSide = ThisWorkbook.Worksheets("Summary").Range("B" & Target.Row).Value
    mcNewLimit = InputBox("Enter the new Limit", "New Limit")
    Range("S3").Value = mcNewLimit
    If mcNewLimit = vbCancel Then
        Exit Sub
    End If
    mcNewLimit = mcNewLimit / 100

When I hit cancel, I can't exit the sub for some reason. What am I doing wrong here?

 

[Trevor G]

Look here to see if it helps

http://www.mrexcel.com/archive/VBA/21801.html

 

[Comfy]

Dim mcSide As Variant
    Dim mcCellSide As Variant
    Dim mcNewLimit As Variant
    
    mcSide = ThisWorkbook.Worksheets("Summary").Range("B" & Target.Row).Value
    mcNewLimit = InputBox("Enter the new Limit", "New Limit")
    Range("S3").Value = mcNewLimit
    If mcNewLimit = vbNullString Then
        Exit Sub
    End If
    mcNewLimit = mcNewLimit / 100

vbYes, vbNo and vbCancel work for an MsgBox

 

[cicconmr]

Solved, NullString was the answer. Thank you so much!