VBA Val Function
This tutorial will demonstrate how to use the Val VBA function.
Val Function
VBA Val Convert Expression to Number
The VBA Val function converts an expression to a number. Val function will return 0 if the first character is non-numerical. It ignores spaces and it will stop evaluating as soon as it finds a character that has no numerical meaning.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
Sub ValExample_1() MsgBox Val("Hello World!") 'Result is: 0 MsgBox Val("1Hello World!") 'Result is: 1 MsgBox Val("Hello World!1") 'Result is: 0 MsgBox Val("1600 Pennsylvania Avenue NW, Washington, DC 20500, United States") 'Result is: 1600 MsgBox Val("1 2 3 4 5") 'Result is: 12345 MsgBox Val("1 2A 3 4 5") 'Result is: 12 MsgBox Val("12.34 5") 'Result is: 12.345 MsgBox Val("67,8 9 ") 'Result is: 67 MsgBox Val("27 28 High Street") 'Result is: 2728 MsgBox Val(" 27 28 High Street") 'Result is: 2728 MsgBox Val("27 - 28 High Street") 'Result is: 27 End Sub |
VBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro - A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!
Learn More!