Newbie: Strange behavior of a comparison

[agual]

In the following snippet

option explicit
dim i: i=5
dim f: f=inputbox ("","",0) 
msgbox "f=" & f & "   i="& i & "   f<i is " & (f<i) & "   f<5 is " & (F<5)

Why f<i is always False, no matter which value i enter?



Antoni

http://www.geocities.com/antonigual/index.html

 

[jges]

Variables are case sensitive. You assign a value to "f", then in the msgbox, you use "F". Since "F" is not initialized it will have a null value.

The question is: why did "option explicit" not warn you about "F" not being declared?

 

[jges]

Also, the input box is going to assign a string value to "f"; convert it to an integer (or other type as needed) before the comparison.

option explicit
dim i
i=5
dim f
f=inputbox ("","",0)
msgbox "f=" & Cint(f) & "   i="& i & "   f<i is " & (Cint(f)<i) & "   f<5 is " & (f<5)

 

[agual]

Jges
Your second answer is the good one. Thanks!

Basics have never been case sensitive..

Antoni

http://www.geocities.com/antonigual/index.html

 

[jges]

I realized my mistake shortly after I posted! I'm glad my 2nd answer helped.