Set a type in VBA to nothing?

Question

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 1

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()