Val Function always returning 0

[vijayendra.shukla]

Hi All,

No matter what my string is, i am always getting '0' as a return value from the Val function. Can anyone please explain me why????

sample code:

 MyString = "300 South 10Street"
MyNumber = Val(strMyString)
MsgBox MyNumber

 

[mvptomlinson]

Notice the two variable names you're using. First you declare it as "MyString" and then you refer to it as "strMyString". No good. Change "strMyString" to "MyString" and it will work.

To avoid this in the future, Dim all variables at the beginning of your code, and at the very top of the code module (before any Private Sub or Function) use

Option Explicit
 
Sub your_proc()
    'Your code here
End Sub

 

[somnath_it2006]

Try This:

MyNumber = Val("300 South 10Street")
MsgBox MyNumber

or

MsgBox Val("300 South 10Street")