Share via

Visual Basic for Applications Reference

  • Article

Val Function Example

This example uses the Val function to return the numbers contained in a string.

  Dim MyValue
MyValue = Val("2457")   ' Returns 2457.
MyValue = Val(" 2 45 7")   ' Returns 2457.
MyValue = Val("24 and 57")   ' Returns 24.