Signature (Visual Basic / VBA)
Public Property Get Cube( _
ByVal vDim1 As Long _
, ByVal vDim2 As Long _
, ByVal vDim3 As Long _
) As Variant
Code Examples
Assuming
Dim saTemp As New SparseArray
saTemp.Cube(23, 45, 67) = "SubName"
for example
saTemp.Cube(23, 45, 67) = "SubName"
saTemp.Cube(24, 45, 67) = EmptyValue
Assuming
Dim saTemp As New SparseArray
for example
saTemp.Cube(23, 45, 67) = "SubName"
leaves
saTemp.Cube(23, 45, 67) = "SubName"
Assuming
Dim saTemp As New SparseArray
Dim objTemp As Object
Set objTemp = Nothing
for example
Set saTemp.Cube(23, 45, 67) = objTemp
Public Property Let Cube( _
ByVal vDim1 As Long _
, ByVal vDim2 As Long _
, ByVal vDim3 As Long _
, ByVal vValue As Variant _
)
Public Property Set Cube( _
ByVal vDim1 As Long _
, ByVal vDim2 As Long _
, ByVal vDim3 As Long _
, ByVal vValue As Variant _
)
Parameters
| Parameter | Description |
|---|---|
| vDim1 | First-dimension element number. |
| vDim2 | Second-dimension element number. |
| vDim2 | Third-dimension element number. |
| vDim1 | First-dimension element number. |
| vDim2 | Second-dimension element number. |
| vDim3 | Third-dimension element number. |
| vDim1 | First-dimension element number. |
| vDim2 | Second-dimension element number. |
| vDim3 | Third-dimension element number. |
Return Value
Function returns the value for the specified element. If array element (vDim1, vDim2, vDim3) was not previously set, this function will return an Empty value.
Notes & Version History
| v1.3 BugFix | This Property Get Function has been fixed to support the retrieval of Object and DataObject type Values. Set the Value of an element when using the SparseArray as a three-dimensional array. |
| vValue | Value to which element number (vDim1, vDim2, vDim3) will be set. vValue can be any type of Variant value (vbString, numeric, vbDate, vbArray, etc.) except an Object or DataObject. |
| v1.3 BugFix | The corresponding Property Set Subroutine supports the storage of Object and DataObject type Values. Set the Value of an element when using the SparseArray as a three-dimensional array. |
| vValue | Object or DataObject value to which element number (vDim1, vDim2, vDim3) will be set. |
| v1.3 BugFix | This new Property Set Subroutine has been added to support the storage of Object and DataObject type Values. |