Visual Basic for Applications Functions
From Microsoft ActiveX Data Objects (ADO)
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 |