Left Property

Some of the content in this topic may not be applicable to some languages.

Left property as it applies to the Assistant and CommandBar objects.

Sets or returns the horizontal position of the Office Assistant window (in points), or the distance (in pixels) of the command bar, from the left edge of the specified object relative to the screen. Read/write Long.

expression.Left

*expression   * Required. An expression that returns one of the above objects.

Left property as it applies to the CommandBarButton, CommandBarComboBox, CommandBarControl, and CommandBarPopup objects.

Set or returns the horizontal position of the specified command bar control (in pixels) relative to the left edge of the screen. Returns the distance from the left side of the docking area. Read-only Long.

expression.Left

*expression   * Required. An expression that returns one of the above objects.

Example

As it applies to the Assistant and CommandBar objects.

This example displays the Office Assistant and moves it to the specified position within the application window.

With Assistant
    .Visible = True
    .Left = 300
    .Top = 300
End With

This example moves the command bar named Custom from its docked position along the top of the window to the left edge of the window.

Set myBar = CommandBars("Custom")
With myBar
    .Position = 1
    .RowIndex = 2
    .Left = 0
End With

Applies to | Assistant Object | CommandBar Object | CommandBarButton Object | CommandBarComboBox Object | CommandBarControl Object | CommandBarPopup Object

See Also | Top Property