VBA provides Val(string) function to convert a string representing a valid number to a real number that can be used in calculations.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim x, y As String
Dim result As Integer
x = "23"
y = "100"
result = Val(x) * Val(y)
MsgBox "Result=" & result
Posted by: Dara | post date: 02-25-2013 | Subject: VBA for MS Excel
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: