DiseaseSheet

Internal members (not exported)

Factory

Create #

Instantiate a sheet builder with provided dependencies.

Signature:

Public Function Create(ByVal hostWorkbook As Workbook, _
                       ByVal dropdowns As DropdownLists, _
                       ByVal varObj As MasterSetupVariables) As DiseaseSheet

Maintenance

FrameTable #

Frame every cell of a disease table with the dotted gray border.

Signature:

Public Sub FrameTable(ByVal diseaseTable As ListObject)

The door for the two paths that grow a disease table after its build: the ribbon's Add Rows and the importer's append. A row added through ListRows.Add takes the vertical edges of the row above and no horizontal edge, and a table grown through ListObject.Resize takes no format at all, so the frame is painted again over the whole table. The call is stateless and runs on the predeclared instance.

Parameters:

Internal Helpers

WriteLineFormulas #

Put the label and the choice values formulas back on every line of a disease table.

Signature:

Public Sub WriteLineFormulas(ByVal diseaseTable As ListObject)

The build writes the two columns here once the table exists, an import writes values over them because a merge copies whole lines, and a table grown through Resize takes no formula on its new rows. The master setup answers those two columns itself, through the worksheet functions, so the formulas go on every line each time. The table has to be one this class built: the columns are found by the headers it writes.

Parameters:

LabelFormula #

The label formula of a line: the worksheet function over the name cell.

Signature:

Private Function LabelFormula(ByVal nameCell As Range, ByVal langAddress As String) As String

ChoiceValuesFormula #

The choice values formula of a line: the worksheet function over the choice cell.

Signature:

Private Function ChoiceValuesFormula(ByVal choiceCell As Range, ByVal langAddress As String) As String
Used in (16 file(s))