IButtons

Defines the public contract for the Buttons class, exposing worksheet shape creation, placement, and formatting for linelist buttons. Supports large, small, and geo button scopes.

Properties

OutputRange #

Anchor range used for placement

Signature:

Public Property Get OutputRange() As Range: End Property

State accessors.

Returns: Range. Top-left anchor cell.

OutputRange #

Update the anchor range used for placement

Signature:

Public Property Set OutputRange(ByVal rng As Range): End Property

Parameters:

  • rng: Range. Providing the top-left anchor cell.

Name #

Name of the shape in the worksheet

Signature:

Public Property Get Name() As String: End Property

Returns: String. Shape identifier.

ShapeScope #

Formatting scope applied to the button

Signature:

Public Property Get ShapeScope() As Byte: End Property

Returns: Byte. ButtonScope value.

Operations

Add #

Create a button shape at the configured location

Signature:

Public Sub Add(Optional ByVal actionCommand As String = vbNullString, _
               Optional ByVal shapeLabel As String = vbNullString): End Sub

Button creation and formatting.

Parameters:

  • actionCommand: String. Macro to execute on click. Defaults to vbNullString.
  • shapeLabel: String. Label displayed on the button. Defaults to vbNullString.

Format #

Apply a design provider to an existing button shape

Signature:

Public Sub Format(design As ILLFormat): End Sub

Parameters:

  • design: ILLFormat. Formatter responsible for styling the shape.
Checkings

HasCheckings #

Whether diagnostic entries have been recorded

Signature:

Public Property Get HasCheckings() As Boolean: End Property

Diagnostic logging access.

Returns: Boolean. True when at least one entry exists.

CheckingValues #

Retrieve the diagnostic log entries

Signature:

Public Property Get CheckingValues() As Object: End Property

Returns: Object. The checking instance, or Nothing.