Consulting

Results 1 to 2 of 2

Thread: Excel VBA dynamic array in a class

  1. #1
    VBAX Regular
    Joined
    Oct 2010
    Posts
    8
    Location

    Excel VBA dynamic array in a class

    Hi,
    Excel 2003
    I need to define a 2 dimensional dynamic array in a VBA Class1 and then use the array in another VBA Class2.
    Class1 populates the array from a database.

    Any help/suggestions would be greatly appreciated.
    Is there a reference for using dynamic arrays in VBA classes?

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    More information required.

    Will the class only be accessed from the other class? If so, just instantiate class A from within class B. If it needs to be accessed from elsewhere you need to do something else.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •