CODEWITHSUNDEEP
excelvbastructureuser-defined-types
Name
Name

Reputation: 209

Intellisense is not working for my User Defined Type in VBA

I made a structure:

Type AntennaParameters
    Private Model As String
    Private AntennaMasterName As String
    Private LowPorts As Integer
    Private MidPorts As Integer
    Private HighPorts As Integer
End Type

When I reference a variable of that type such as:

Dim struct As AntennaParameters
struct.Model

I don't see a list of all the variables inside that UDT. Is there a fix for this?

Upvotes: 0

Views: 231

Answers (1)

ArcherBird
ArcherBird

Reputation: 2134

Remove the Private access modifier from each element. It is not a part of the syntax for making a vba Type

Type AntennaParameters
    Model As String
    AntennaMasterName As String
    LowPorts As Integer
    MidPorts As Integer
    HighPorts As Integer
End Type

Upvotes: 2

Related Questions