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

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!

  3. 01 Jan 1999 at 00:00

    This thread is for discussions of Number Functions.

Leave a comment

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

James Crowley James first started this website when learning Visual Basic back in 1999 whilst studying his GCSEs. The site grew steadily over the years while being run as a hobby - to a regular monthly audience ...
AddThis

Related discussion

Related podcasts

  • Christian Beauclair

    14 mai 2008 (�mission #0074) ::.Christian Beauclair: Stratégies de migration VB6 vers .NET Nous discutons avec Christian Beauclair des stratégies de migration VB6 vers .NET. Entre autres, nous discutons comment utiliser le "VB 6 Code Advisor" et le "Interop Forms Toolkit" pour ajouter la puiss...

Want to stay in touch with what's going on? Follow us on twitter!