IListBuilder

Defines the public contract for the ListBuilder class, exposing a single Build method that constructs an HList (horizontal) or VList (vertical) data entry sheet with formatting, freeze panes, sections, buttons, ListObjects, and worksheet protection. ListBuilderLayer modes: HList is horizontal, VList is vertical.

Operations

Build #

Build the data entry sheet

Signature:

Public Sub Build()

Data entry sheet construction. Dispatches to the appropriate builder based on the layer mode set during factory construction. HList mode creates a horizontal data entry sheet with a ListObject table, printed companion sheet, filtered companion sheet, buttons, and pivot table. VList mode creates a vertical data entry sheet with sections, a GoTo dropdown, and PLAGEVALUES range reference. Both modes apply formatting, freeze panes, build sections via SectionBuilder, and protect the sheet.

Checkings

HasCheckings #

Whether the builder has logged diagnostic messages

Signature:

Public Property Get HasCheckings() As Boolean

Diagnostic logging access for sheet build results.

Returns: Boolean. True when diagnostic entries exist.

CheckingValues #

Retrieve the diagnostic log entries

Signature:

Public Property Get CheckingValues() As IChecking

Returns: IChecking. The checking instance, or Nothing.