Consulting

Results 1 to 3 of 3

Thread: Looping through dim'ed objects - can it be done?

  1. #1
    VBAX Mentor
    Joined
    Aug 2012
    Posts
    367
    Location

    Looping through dim'ed objects - can it be done?

    hi all,

    Do objects declared inside a subroutine form some sort of collection that can be looped through, or must they be referenced manually?

    my thought is to make a "with each" loop to set each object variable back to nothing when exiting a sub - but I don't know the right syntax to search for help under.

    Is this possible?
    is it wise?

    Thanks
    Remember: it is the second mouse that gets the cheese.....

  2. #2
    VBAX Expert JP2112's Avatar
    Joined
    Oct 2008
    Location
    Astoria, NY
    Posts
    590
    Location
    I'm afraid not -- my assumption is that since variables are created by the developer at design time, then the developer can do that at design time as well.
    Regards,
    JP

    Read the FAQ
    Getting free help on the web
    My website
    Please use [vba][/vba] tags when posting code

  3. #3
    VBAX Mentor
    Joined
    Aug 2012
    Posts
    367
    Location
    I figured something like this - but thanks for the reply
    Remember: it is the second mouse that gets the cheese.....

Posting Permissions

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