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.

When VBA support is enabled, %PRODUCTNAME Basic function arguments and return values are the same as their VBA functions counterparts. When the support is disabled, %PRODUCTNAME Basic functions may accept arguments and return values different of their VBA counterparts.

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