Set a type in VBA to nothing?

vba object variables user-defined-types
tyrex picture tyrex · Mar 20, 2012 · Viewed 25k times · Source

I have defined a variable with an own type, say

Dim point As DataPoint

Public Type DataPoint
   list as Collection
   name as String
   number as Integer
End Type

and I want to delete all values of the variable point at once. If it was a class, I would just use Set point = New DataPoint, or set Set point = Nothing, but how can I proceed if it's a type?

Answer

GSerg picture GSerg · Mar 20, 2012

You can benefit from the fact that functions in VB have an implicit variable that holds the result, and that contains the default type value by default.

public function GetBlankPoint() as DataPoint
end function

Usage:

point = GetBlankPoint()

Related questions

VBA Check if variable is empty

I have an object and within it I wanna check if some properties is set to false, like: If (not objresult.EOF) Then 'Some code End if But somehow, sometimes objresult.EOF is Empty, and how can I check it? …

Read More
Parsing JSON in Excel VBA

I have the same issue as in Excel VBA: Parsed JSON Object Loop but cannot find any solution. My JSON has nested objects so suggested solution like VBJSON and vba-json do not work for me. I also fixed one of …

Read More
Determining whether an object is a member of a collection in VBA

How do I determine whether an object is a member of a collection in VBA? Specifically, I need to find out whether a table definition is a member of the TableDefs collection.

Read More