+ Reply to Thread
Results 1 to 2 of 2

Storing a Dictionary into a Dictionary Object

  1. #1
    Registered User
    Join Date
    07-15-2015
    Location
    australia
    MS-Off Ver
    2010
    Posts
    1

    Cool Storing a Dictionary into a Dictionary Object

    Hi,

    I am newbie to vba programming and so anything you can contribute here would be deeply appreciated.

    I would like you to have a look at the sub for processData() and tell me why, in this example, 6 new instances of new dictionaries were created within the same sub routine:

    http://www.techbookreport.com/tutori...ctionary2.html.

    Are they really necessary? What function, if any, do they serve?

    Will you get errors if you leave the last three instances of dictionary object references out?

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

    Thanks,

    pg
    Last edited by JBeaucaire; 07-16-2015 at 01:05 AM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,985

    Re: Storing a Dictionary into a Dictionary Object

    The code won't work if you remove them. You need to look at the structure of the If... Else... End if part.
    Everyone who confuses correlation and causation ends up dead.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dictionary - Using a dictionary of dictionaries to hold individual orders
    By wazimu13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2015, 08:32 PM
  2. [SOLVED] Dictionary with Custom Object as Value
    By mtnbiker98 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-26-2013, 04:05 PM
  3. Object - Scripting.Dictionary
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2013, 06:00 AM
  4. Faster alternative to dictionary object?
    By gpotter_htg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2011, 05:09 PM
  5. Dictionary Object in Excel?
    By danny2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-03-2009, 02:20 AM
  6. Dictionary Object
    By AdamDay in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-29-2008, 07:44 PM
  7. [SOLVED] Dictionary Object in Windows XP
    By Alan Beban in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2005, 05:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1