---
title: "Visual Basic for Applications functions | Microsoft Docs"
ms.prod: sql
ms.prod_service: connectivity
ms.technology: connectivity
ms.custom: ""
ms.date: "01/19/2017"
ms.reviewer: ""
ms.topic: conceptual
dev_langs: 
  - "VB"
helpviewer_keywords: 
  - "Visual Basic for applications functions [ADO]"
  - "data shaping [ADO], Visual Basic for Applications functions"
ms.assetid: ccbdea9d-f9cf-4b0c-ade2-2d65311e12dc
author: MightyPen
ms.author: genemi
---
# Visual Basic for Applications functions
The following Visual Basic for Applications functions can be used in data shaping CALC expressions:  
  
|||||||  
|-|-|-|-|-|-|  
|Abs|Asc|Atn|CBool|CByte|CCur|  
|CDate|CDbl|Chr|ChrB|ChrW|Chr$|  
|ChrB$|CInt|CLng|Cos|CSng|CStr|  
|Cvar|CVDate|CVErr|Date|Date$|DateAdd|  
|DateDiff|DatePart|DateSerial|DateValue|Day|DDB|  
|Error|Error$|Exp|Fix|Format|Format$|  
|FV|Hex|Hex$|Hour|IIF|InStr|  
|Int|IPmt|IRR|IsDate|IsEmpty|IsError|  
|IsNull|IsNumeric|IsObject|LCase|LCase$|Left|  
|LeftB|Left$|LeftB$|Len|Log|LTrim|  
|LTrim$|Mid|Mid$|Minute|MIRR|Month|  
|Now|NPer|NPV|Oct|Oct$|Pmt|  
|PPmt|PV|QBColor|Rate|RGB|Right|  
|RightB|Right$|RightB$|Rnd|RTrim|RTrim$|  
|Second|Sgn|Sin|SLN|Space|Space$|  
|Sqr|Str|Str$|StrComp|StrConv|String|  
|String$|SYD|Tan|Time|Time$|Timer|  
|TimeSerial|TimeValue|Trim|Trim$|TypeName|UCase|  
|UCase$|Val|VarType|Weekday|Year||  
  
## See Also  
 [Accessing Rows in a Hierarchical Recordset](../../../ado/guide/data/accessing-rows-in-a-hierarchical-recordset.md)   
 [Data Shaping Overview](../../../ado/guide/data/data-shaping-overview.md)   
 [Formal Shape Grammar](../../../ado/guide/data/formal-shape-grammar.md)   
 [Required Providers for Data Shaping](../../../ado/guide/data/required-providers-for-data-shaping.md)   
 [Shape APPEND Clause](../../../ado/guide/data/shape-append-clause.md)   
 [Shape Commands in General](../../../ado/guide/data/shape-commands-in-general.md)   
 [Shape COMPUTE Clause](../../../ado/guide/data/shape-compute-clause.md)