VBA Data Type within another Data Type

Question

I am trying to us a Type within another type but it is not letting me.

Public Type MyTable
     Name As String
     IDStartingNumber As Integer
     Items(50) As MyItem
End Type

Public Type MyItem
    Name As String
    DataType As DataTypes
    Number As Integer
    AllowNull As Boolean
    Unique As Boolean
    Reference As MyTable
End Type

What is going on and how do I fix this?

What error do you get?

SLaks
– SLaks

2013-07-07 02:42:53 +00:00
Commented Jul 7, 2013 at 2:42 — SLaks
– SLaks, Commented Jul 7, 2013 at 2:42
"Compile Error: Forward reference to user-defined type"

Makai
– Makai

2013-07-07 02:44:34 +00:00
Commented Jul 7, 2013 at 2:44 — Makai
– Makai, Commented Jul 7, 2013 at 2:44

dennythecoder · Accepted Answer · 2013-07-07 02:45:50Z

6

Make sure the type you're referencing is before it. In your example you have the MyItem type afterwards. For example:

Public Type MyItem
    Name As String
    DataType As DataTypes
    Number As Integer
    AllowNull As Boolean
    Unique As Boolean
    Reference As MyTable
End Type

Public Type MyTable
     Name As String
     IDStartingNumber As Integer
     Items(50) As MyItem
End Type

answered Jul 7, 2013 at 2:45

dennythecoder

8226 silver badges21 bronze badges

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

Comments

SlartyBartFast · Accepted Answer · 2019-01-29 15:38:57Z

0

In both examples, it appears one type references the other, so neither example should work.

i.e.

Public Type MyTable Name As String IDStartingNumber As Integer Items(50) As MyItem End Type

Public Type MyItem Name As String DataType As DataTypes Number As Integer AllowNull As Boolean Unique As Boolean Reference As MyTable End Type

You cannot have one type refer to a different type which refers back to the first type.

answered Jan 29, 2019 at 15:38

SlartyBartFast

1

Collectives™ on Stack Overflow

VBA Data Type within another Data Type

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related