Class ModelTableColumn (Excel VBA)

The class ModelTableColumn represents a single column inside a ModelTable object.

Set

To use a ModelTableColumn class variable it first needs to be instantiated, for example

Dim lngIndex As Long: lngIndex = 
Dim mdlt As ModelTable: Set mdlt = 
Dim mtcModelTableColumn As ModelTableColumn
Set mtcModelTableColumn = mdlt.ModelTableColumns(Index:=lngIndex)

The following procedures can be used to set variables of type ModelTableColumn: ModelRelationship.ForeignKeyColumn, ModelRelationship.PrimaryKeyColumn, ModelTableColumns.Item and ModelTable.ModelTableColumns

For Each

Here is an example of processing the ModelTableColumn items in a collection.

Dim mdlt As ModelTable: Set mdlt = 
Dim mtcModelTableColumn As ModelTableColumn
For Each mtcModelTableColumn In mdlt.ModelTableColumns
	
Next mtcModelTableColumn

DataType

Returns the XlParameterDataType enumeration of the ModelTableColumn.

Name

Returns a String value that represents the name of the object.

Parent

Returns an object that represents the parent object of the specified ModelTableColumn object. Read-only.

ModelTableColumns.Count

Returns a Long value that represents the number of ModelTableColumn objects in a ModelTableColumns object.

ModelTableColumns.Item

Returns a ModelTableColumn object from the ModelTableColumns collection.

Syntax : expression.Item (Index)

Index: The index number for the object.

ModelTableColumns.Parent

Returns an object that represents the parent object of the specified ModelTableColumns object. Read-only.