Library tutorials & articles

Number Functions

Page 1 of 3
  1. Conversion Functions
  2. Random Numbers
  3. More...

Conversion Functions

To get any numbers contained in a string you can use the Val Function. The Val function uses the following syntax:

Val(String)

The following code gets any numbers contained in String, and puts it into a textbox

Dim sNum As String
sNum = "Year: 2000, date: 12"
' Text1 will contain 200012
Text1.Text = Val(sNum)

You can also convert numbers to different types. For example, the Int function converts any number to a Integer (whole number). The following code will display a message box with 123 in it.

Dim fNum As Single
fNum = 1234.90
Msgbox Int(fNum)

You can also use the following commands:

Int - Converts a number to a Integer
CLng - Converts a number to a Long
Hex - Converts a number to Hex

AddThis

Comments

  1. 28 Apr 2003 at 14:25

    Dim sNum As String
    sNum = "Year: 2000, date: 12"
    ' Text1 will contain 200012
    Text1.Text = Val(sNum)


    This code is flat-out wrong.


    The VAL function searches the source string, converting the string to a numeric value until it reaches the first non-numeric character. Since this example BEGINS with a non-numeric character, the returned value will be zero (0).

  2. 01 Apr 2003 at 21:42

    Anywho, the last page is a bit wasteful, don't you think?
    [edit] O_o I went there again and it had gone back to 9999! Hehe, I did it twice!

Leave a comment

Sign in or Join us (it's free).

Related discussion