Excel Topics: VBA Functions (By Category)
View an Alphabetical Listing of VBA Functions
String Functions: |
||||
| Asc | InStrRev | Replace | Trim | |
| Chr | LCase | Right | UCase | |
| Concatenate with & | Left | RTrim | Val | |
| CurDir | Len | Space | ||
| Format Strings | LTrim | Str | ||
| InStr | Mid | StrConv | ||
Numeric / Mathematical Functions: |
||||
| Abs | Fix | Rnd | Tan | |
| Atn | Format Numbers | Round | ||
| Cos | Int | Sgn | ||
| Exp | Log | Sin | ||
Logical Functions: |
||||
| Case | IF-THEN-ELSE | |||
Information Functions: |
||||
| IsDate | IsError | IsNull | IsNumeric | |
Date & Time Functions: |
||||
| Date | DateValue | Month | Weekday | |
| DateAdd | Day | MonthName | WeekdayName | |
| DateDiff | Format Dates | Now | Year | |
| DatePart | Hour | TimeSerial | ||
| DateSerial | Minute | TimeValue | ||
Lookup / Reference Functions: |
||||
| Choose | ||||
| Switch | ||||
Data Type Conversion Functions: |
||||
| CBool | CDate | CInt | CStr | |
| CByte | CDbl | CLng | CVar | |
| CCur | CDec | CSng | ||
Financial Functions: |
||||
| DDb | Mirr | PPmt | Syd | |
| FV | NPer | PV | ||
| IPmt | Npv | Rate | ||
| Irr | Pmt | SLn | ||
File/Directory Functions: |
||||
| ChDir | Dir | FileLen | MkDir | |
| ChDrive | FileDateTime | GetAttr | SetAttr | |