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.