Option VBASupport Statement

Specifies that LibreOffice Basic will support some VBA statements, functions and objects.

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

The support for VBA is not complete, but covers a large portion of the common usage patterns.


Option VBASupport {1|0}


แƒ’แƒแƒ•แƒ แƒ—แƒฎแƒ˜แƒšแƒ”แƒ‘แƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

This statement must be added before the executable program code in a module.

1: Enable VBA support in LibreOffice

0: Disable VBA support


Option VBASupport 1

Sub ExampleVBA

Dim sVar As Single

 sVar = Worksheets("Sheet1").Range("A1")

Print sVar

End Sub