VBA Excel: Compile Error: Object required?

Question

I get a VBA Excel 'Compiler Error: Object required'-Error in the marked line. I do not understand the reason. BTW: Wish Excel would support a .Net language without wrapper needs. ``` Option Explicit Public Type Inherit ReqId As Integer Parent As Integer Depth As Integer Path As String End Type Sub test() Dim MyStructure() As Inherit ReDim MyStructure(1 To 1000) MyStructure(1).ReqId = 1 Dim Data, refData As Inherit Set Data = MyStructure(1) ' <---! Beep End Sub ```

Accepted Answer

`Set` is for the assignment of objects, a user defined type is treated like a regular variable so use `=` to assign.

Also (confusingly); `Dim Data, refData As Inherit` only declares `refData` of type `Inherit` to declare them both on one line you must; `Dim Data As Inherit, refData As Inherit`

VBA Excel: Compile Error: Object required?

Solution

Problem