Skip to Content
VBScript in a Nutshell
book

VBScript in a Nutshell

by Matt Childs, Paul Lomax, Ron Petrusha
May 1995
Beginner
508 pages
16h 14m
English
O'Reilly Media, Inc.
Content preview from VBScript in a Nutshell

Name

CLng Function

Syntax

CLng(expression)
expression

Use: Required

Data Subtype: Numeric or String

The range of expression is -2,147,483,648 to 2,147,483,647; fractions are rounded.

Return Value

expression cast as a Variant with a subtype of Long.

Description

Converts expression to a Variant with a subtype of Long; any fractional element of expression is rounded.

Rules at a Glance

  • expression must evaluate to a numeric value; otherwise, a type mismatch error is generated.

  • If the value of expression is outside the range of the long datatype, an overflow error is generated.

  • When the fractional part is exactly 0.5, CLng always rounds it to the nearest even number. For example, 0.5 rounds to 0, and 1.5 rounds to 2.

Example

<HTML>
<HEAD>
<SCRIPT LANGUAGE="VBScript">
Option Explicit

Sub cmdAdd_OnClick( )

   Dim lSum, sNum1, sNum2
   
   sNum1 = Window.Document.frmAdd.txtText1.Value
   sNum2 = Window.Document.frmAdd.txtText2.Value
   If IsNumeric(sNum1) And IsNumeric(sNum2) Then
      lSum = CLng(sNum1) + CLng(sNum2)
      Alert "The sum is: " & lSum
   Else
      Alert "The values you enter in the text boxes must be numeric."
   End If
End Sub
</SCRIPT>
</HEAD>

<BODY>
<FORM NAME="frmAdd">
   <INPUT TYPE="text" NAME="txtText1"><BR>
   <INPUT TYPE="text" NAME="txtText2"><BR>
   <INPUT TYPE="button" NAME="cmdAdd" VALUE="Sum">
</FORM>
</BODY>
</HTML>

Programming Tips & Gotchas

  • Use IsNumeric to test whether expression evaluates to a number.

  • CLng differs from the Fix and Int functions, which truncate, rather than round, the fractional part of a number. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Microsoft® VBScript Step by Step

Microsoft® VBScript Step by Step

Ed Wilson
VBScript Programmer's Reference, Third Edition

VBScript Programmer's Reference, Third Edition

Kathie Kingsley-Hughes, Daniel Read, Adrian Kingsley-Hughes
VBScript in a Nutshell, 2nd Edition

VBScript in a Nutshell, 2nd Edition

Paul Lomax, Matt Childs, Ron Petrusha
VBScript Pocket Reference

VBScript Pocket Reference

Paul Lomax, Matt Childs, Ron Petrusha

Publisher Resources

ISBN: 1565927206Catalog PageErrata