Microsoft Office Development and Consultancy
 Home|Excel|

VBA

|C#|Finance|Tools|Newsletter|Feedback|Contact 
 VBA > Datatypes< Previous | Next > 

 

Basic

 
Expand

 -

Getting Started

Step By Step

 -

Summary

Step By Step

 -

Type Conversion

Step By Step

 -

Object Datatype

Step By Step

 -

Variant Datatype

Step By Step

 -

TypeName Function

Step By Step

 -

User Defined Type


 

Functions

 
GoTo

 -

CBOOL - Returns the expression converted to a boolean datatype (Boolean).

GoTo

 -

CBYTE - Returns the expression converted to a byte datatype (Byte).

GoTo

 -

CCUR - Returns the expression converted to a currency datatype (Currency).

GoTo

 -

CDATE - Returns the expression converted to a date datatype (Date).

GoTo

 -

CDBL - Returns the expression converted to a double datatype (Double).

GoTo

 -

CDEC - Returns the expression converted to a decimal subtype (Variant).

GoTo

 -

CINT - Returns the expression converted to an integer datatype (Integer).

GoTo

 -

CLNG - Returns the expression converted to a long datatype (Long).

GoTo

 -

CSNG - Returns the expression converted to a single datatype (Single).

GoTo

 -

CSTR - Returns the expression converted to a string datatype (String).

GoTo

 -

CVDATE - Returns the expression converted to a date datatype (Variant).

GoTo

 -

CVAR - Returns the expression converted to a variant datatype (Variant).

GoTo

 -

CVERR - Returns the corresponding to a given error number (Variant).

GoTo

 -

FIX - Returns the integer portion of a number (Integer).

GoTo

 -

INT - Returns the number rounded down to the nearest integer (Integer).

GoTo

 -

IS - (Operator) An object reference comparison operator.

GoTo

 -

ISDATE - Returns the value indicating if an expression is a date (Boolean).

GoTo

 -

ISOBJECT - Returns the value indicating if an identifier represents an object (Boolean).

GoTo

 -

TYPENAME - Returns the datatype of the variable as a string (String).

GoTo

 -

VARTYPE - Returns the number indicating the type of a variable (Integer).


 

Advanced

 
More Details

 -

DefType

More Details

 -

Advanced Techniques

More Details

 -

Knowledge Base

More Details

 -

Knowledge Base - Numerical

More Details

 -

Code Snippets


 

Related Topics

 
GoTo

 -

Objects

GoTo

 -

Variables


 © Better Solutions Limited 01-Jun-2013Top