IDiseaseSheet

Initialise #

Configure builder dependencies.

Signature:

Public Sub Initialise(ByVal hostWorkbook As Workbook, _
                      ByVal dropdowns As IDropdownLists, _
                      ByVal translations As ITranslationObject, _
                      ByVal varObj As IMasterSetupVariables)

Parameters:

• hostWorkbook: Workbook where disease sheets are created.
• dropdowns: IDropdownLists providing data validation helpers.
• translations: ITranslationObject supplying translated labels.

---

Build #

Create a disease worksheet populated with metadata, headers, and validations.

Signature:

Public Function Build(ByVal diseaseName As String, _
                      Optional ByVal languageTag As String = vbNullString) As Worksheet

Parameters:

• diseaseName: String worksheet name to create.
• diseaseIndex: Long sequential index used for names and counters.
• languageTag: Optional String initial language value; defaults to translated prompt.
• options: Optional Dictionary-like BetterArray containing overrides (languageList, statusList, etc.).

Returns: Worksheet freshly created and formatted.

---

Reset #

Reset cached state so the builder can be reused safely.

Signature:

Public Sub Reset()

---