Option VBASupport Statement /text/sbasic/shared/03103350.xhp

Microsoft Excel macros support;Enable Microsoft Excel macros support;Option VBASupport statement VBA Support;Option VBASupport statement Option VBASupport statement

Option VBASupport Statement

Specifies that %PRODUCTNAME 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}

1: Enable VBA support in %PRODUCTNAME 0: Disable VBA support

Option VBASupport 1 Sub ExampleVBA Dim sVar As Single sVar = Worksheets("Sheet1").Range("A1") Print sVar End Sub

VBA Properties VBA support in %PRODUCTNAME