VBA not performing due to data format mismatch

[S Oberlander]

See below code to check for the existence of "mid". My problem is that "mid" is a whole number, and vba is picking up "C" as a scientific number, effectively triggering the MsgBox and Exit Sub regardless if a match is found or not.
How can I have vba pick up "C" as a whole number?

Sub findmid()

    Dim lastrow As Long
    Dim mid As Variant
    Dim C As Range
    
    With ActiveSheet
        lastrow = .Cells(.Rows.Count, "A").End(xlUp).Row
    End With
    mid = Application.InputBox("Enter mid or select cell containing the mid.", "Analyze it")
    For Each C In Range("$B$2:$B$" & lastrow)
        If C.Value = mid = False Then
            MsgBox "Invalid Mid or Mid not found!", vbOKOnly, "Analyze it"
            Exit Sub
        End If
    Exit For
    Next C

End Sub

 

[Joe4]

Firstly, do NOT use reserved words like "MID" as names of variables, functions, or procedures. Reserved words are words already used by Excel for functions, properties, and methods.
Using reserved words can lead to errors and unexpectd results.

Can you provide us with a small sample of what the entries you have in column B look like, and what you are entering in to your Input Box?

 

[Akuini]

Have you tried using .Formula instead of .Value?

If C.Formula = mid = False Then

 

[S Oberlander]

Firstly, do NOT use reserved words like "MID" as names of variables, functions, or procedures.

Lol, totally didn't realize I'm using something reserved, I mean MID as the acronym for "Merchant IDentification number"

 

[Joe4]

Lol, totally didn't realize I'm using something reserved, I mean MID as the acronym for "Merchant IDentification number"

You never heard of the "MID" function (similar to the LEFT and RIGHT functions)?
Just something you need to be aware of. I often preface my variables with the prefix "My" to avoid that from happening.

 

[S Oberlander]

You never heard of the "MID" function (similar to the LEFT and RIGHT functions)?
Just something you need to be aware of. I often preface my variables with the prefix "My" to avoid that from happening.

I did, and I've used it too... I just didn't realize when I wrote it.
Its actually an error I make quite often with other reserved words... Using "My" sounds like a great idea.