LLVariables

Internal members (not exported)

CacheManagement

ResetCaches #

Signature:

Private Sub ResetCaches()

InvalidateCaches #

Signature:

Public 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 searchText 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

VariableNames #

Signature:

Public Function VariableNames() 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:

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

ControlType #

Signature:

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

TableName #

Signature:

Public 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
Used in (28 file(s))