LLVariables

CacheManagement

ResetCaches #

Signature:

Private Sub ResetCaches()

InvalidateCaches #

Signature:

Private Sub InvalidateCaches()

EnsureDictionaryReady #

Signature:

Private Sub EnsureDictionaryReady()

RefreshVariableRange #

Signature:

Private Sub RefreshVariableRange()

EnsureVariableRange #

Signature:

Private Sub EnsureVariableRange()

CacheKeyForColumn #

Signature:

Private Function CacheKeyForColumn(ByVal colName As String) As String

TryGetCachedColumnIndex #

Signature:

Private Function TryGetCachedColumnIndex(ByVal cacheKey As String, ByRef cachedIndex As Long) As Boolean

StoreColumnIndex #

Signature:

Private Sub StoreColumnIndex(ByVal cacheKey As String, ByVal columnIndexValue As Long)

SanitizeSearchTerm #

Signature:

Private Function SanitizeSearchTerm(ByVal value As String) As String

FindVariableCell #

Signature:

Private Function FindVariableCell(ByVal varName As String, _ 
                                  Optional ByVal matchCase As Boolean = True) As Range

ResolveColumnIndex #

Signature:

Private Function ResolveColumnIndex(ByVal colName As String, Optional ByVal required As Boolean = False) As Long

VariableNamesList #

Signature:

Private Function VariableNamesList() As BetterArray

Logging

LogInfo #

Signature:

Private Sub LogInfo(ByVal label As String, _
                    Optional ByVal varName As String = vbNullString, _
                    Optional ByVal colName As String = vbNullString, _ 
                    Optional ByVal scope As Byte = checkingInfo)

SheetName #

Signature:

Private Function SheetName(ByVal varName As String, Optional ByVal matchCase As Boolean = True) As String

ControlType #

Signature:

Private Function ControlType(ByVal varName As String, Optional ByVal matchCase As Boolean = True) As String

TableName #

Signature:

Private Function TableName(ByVal varName As String) As String

CellRangeInternal #

Signature:

Private Function CellRangeInternal(ByVal colName As String, ByVal varName As String, ByVal matchCase As Boolean) As Range

ColumnValue #

Signature:

Private Function ColumnValue(ByVal varName As String, ByVal columnName As String, ByVal matchCase As Boolean) As String

• AnalysisOutput.cls
• CrossTable.cls
• TableSpecs.cls
• LLImporter.cls
• ILLVariables.cls
• LLExport.cls
• LLSheets.cls
• LLVariables.cls
• FormulaCondition.cls
• Formulas.cls
• ValueOfFormula.cls
• LLGeo.cls
• EventLinelist.cls
• IEventLinelist.cls
• Linelist.cls
• LinelistSpecs.cls
• SectionBuilder.cls
• VarWriter.cls
• EventSetup.cls
• SetupErrors.cls
• ShowHideManager.cls
• LinelistEvents.bas
• EventsLinelistButtons.bas
• MasterSetupHelpers.bas
• SetupHelpers.bas
• LinelistEvents.bas
• TestLLSheetsExtra.bas
• TestLLVariables.bas
• TestLLVariablesExtra.bas
• TestFormulaCondition.bas
• TestFormulas.bas
• TestValueOfFormula.bas
• TestVarWriter.bas
• LLVarContextVariablesStub.cls