Left Property

Microsoft Office Visual Basic

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.

ShowLeft 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

ShowAs 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