Issue with If Statement in excel VBA

[creaseA]

I am a strange issue occurring that I can not seem to find the answer to.
Here is snippet of code:

If value1 > value2 Then
MsgBox(message)
End If

I have ensured that value1 is less than value2, yet each time the code runs I get the message in the message box. Value 1 and Value 2 are defined and given values immediately prior to the If statement. (Can not share rest of code)
Other If statements in the code work as expected but the message in this if statement runs no matter the values of Value1 and Value 2.

Any help here would be appreciated.

 

[creaseA]

yes, that is correct. i used to declare variables like that until i learned that if you don't explicitly state the variable type for each variable, then it defaults to variant.

you can still do them on the same line, it would just read like Dim var1 as Double, var2 as Double, etc.

on a side note, i use a form of hungarian notation, where i add a 3-byte variable type prefix to my variables. it makes it much easier to keep track of in the code and i know just to look at the variable what data type it is. perhaps you may find it useful to adopt such a practice.

Dim dblValue1   As Double
Dim dblValue2   As Double
Dim strValue1   As String
Dim lngValue1   As Long

Thats a cool idea! Thanks for help!