ITranslationObject

Defines the public contract for the TranslationObject class, exposing tag-based translation of strings, ranges, and user-form controls from a ListObject translation table keyed by language column.

Elements

Name #

Name of the translation object

Signature:

Public Property Get Name() As String

Core translation accessors and lookups.

Returns: String. Descriptive identifier including table and language.

Language #

Current language header associated with the translation table

Signature:

Public Property Get Language() As String

Returns: String. The active language.

LanguagesList #

List of available language headers

Signature:

Public Property Get LanguagesList() As BetterArray

Returns: BetterArray. Each language header, excluding the helper/tag column.

ValueExists #

Whether a tag exists in the translation table

Signature:

Public Property Get ValueExists(ByVal text As String) As Boolean

Parameters:

  • text: String. Tag to search in the translation table.

Returns: Boolean. True when the tag exists for the configured language.

TranslatedValue #

Translate a text tag or formula string

Signature:

Public Function TranslatedValue(ByVal Text As String, Optional ByVal containsFormula As Boolean = False) As String

Parameters:

  • Text: String. Text to translate.
  • containsFormula: Boolean. When True, only quoted chunks are translated. Defaults to False.

Returns: String. The translated value, or the original text when no translation was found.

Outside

TranslateForm #

Translate all supported controls on a user form

Signature:

Public Sub TranslateForm(ByVal UserFrm As Object)

Bulk translation of forms and ranges.

Parameters:

  • UserFrm: Object. Any user form exposing a Controls collection.

TranslateRange #

Translate all values in a column range

Signature:

Public Sub TranslateRange(ByVal colRng As Range, Optional ByVal containsFormula As Boolean = False)

Parameters:

  • colRng: Range. Column range whose values should be translated.
  • containsFormula: Boolean. When True, translates as formulas. Defaults to False.
Checkings

HasCheckings #

Whether the translator logged diagnostic notes

Signature:

Public Property Get HasCheckings() As Boolean: End Property

Diagnostic logging access.

Returns: Boolean. True when at least one entry exists.

CheckingValues #

Retrieve the diagnostic log entries

Signature:

Public Property Get CheckingValues() As Object: End Property

Returns: Object. The checking instance, or Nothing.