Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Set Statement

Sets an object reference on a variable.

Syntax:

Set Statement diagram


   [Set] variable = [New] object

Parameters:

variable: a variable or a property that requires an object reference.

expression: A computable combination of terms such as a formula or an object property or method.

object: Object that the variable refers to.

Nothing - Assign Nothing to a variable to remove a previous assignment.

Set keyword is optional. Nothing is the default value for objects.

Example:


Sub ExampleSet
    Dim obj As Object
    Set obj = ThisComponent
    Print obj.Title
 
    obj = New com.sun.star.beans.PropertyValue
    With obj
        .Name = "key" : .Value = 594.34
        Print .Name, .Value
    End With
End Sub

New creates UNO objects or class module objects, before assigning it to a variable.