Nested structures in VBA

Question

How can I create a nested structure in VBA? When I try the following code in VB Editor it is saying "Statement invalid inside type block".

Type Functiondetails

    Function As String
    Sites(7) As String
    Values(7) As Integer

End Type

Type Financialdetails

    Metrics As String

    Dim f(10) As Functiondetials    

End Type

Alex K. · Accepted Answer · 2012-01-07 19:11:18Z

2

Remove the Dim from the 2nd Type (and spell Functiondetails correctly!);

Type Financialdetails
    Metrics As String
    f(10) As Functiondetails
End Type

You should be ok but it also may not like Function as an identifier.

edited Jan 7, 2012 at 19:11

answered Jan 7, 2012 at 19:04

Alex K.

177k32 gold badges276 silver badges299 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Nested structures in VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related