Supported VBA modules in Zoho Sheet
Classes | Properties | Methods |
| <Globals> | All properties and modules under VBA are globals (i.e., they can be used directly without prefixing the respective module name) | All properties and modules under VBA are globals (i.e., they can be used directly without prefixing the respective module name) |
Conversion | No supported properties for this module |
- CBool
- CLng
- CSng
- CStr
- CVDate
- CVar
- Fix
- Hex
- Hex$
- Int
- Oct
- Oct$
- Str
- Str$
- Val
|
|
DateTime |
- Date
- Time$
|
- DateAdd
- DateDiff
- DatePart
- DateSerial
- DateValue
- Day
- Hour
- Minute
- Month
- Second
- TimeSerial
- TimeValue
- Timer
- Weekday
- Year
|
|
Financial | No supported properties for this module |
- FV
- PV
- Pmt
- Rate
- SLN
- SYD
|
|
Information | No supported properties for this module | IsArray
IsDate
IsEmpty
IsNumeric
IsObject
QBColor
RGB
TypeName
VarType
|
|
Interaction | No supported properties for this module |
- Choose
- MsgBox
- InputBox
|
|
Math | No supported properties for this module |
- Abs
- Atn
- Cos
- Exp
- Log
- Rnd
- Round
- Sgn
- Sin
- Sqr
- Tan
|
Strings | No supported properties for this module | - Asc
- AscB
- Ascw
- Chr
- Chr$
- ChrB
- ChrB$
- ChrW
- ChrW$
- Filter
- Filter
- Format
- Format$
- FormatCurrency
- FormatDateTime
- FormatPercent
- FormatNumber
- InStr
- InStrB
- InStrRev
- Join
- LCase
- LCase$
- LTrim
- LTrim$
- Left
- Left$
- LeftB
- LeftB$
- Len
- LenB
- Mid
- Mid$
- MidB
- MidB$
- MonthName
- RTrim
- RTrim$
- Replace
- Right
- Right$
- RightB
- RightB$
- Space
- Space$
- Split
- StrComp
- StrConv
- StrReverse
- String
- String$
- Trim
- Trim$
- UCase
- UCase$
- WeekdayName
|