View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Emulate C/C++ struct in VBA?

I defined one as:

Private Type Test
ID As String
Name As String
Price As Double
End Type

and then defined an array:

Dim Tests(3000) As Test


The error was being caused by having the array being
declared Global. Once I made it Local to a subroutine, it
worked correctly.