Results 1 to 2 of 2

Storing a Dictionary into a Dictionary Object

Threaded View

  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?

    Set peopleDictionary = New Dictionary
    Set salesDictionary = New Dictionary
    Set salesDictionary = peopleDictionary(salesPerson)
    Set salesDictionary = New Dictionary
    Set salesDictionary = peopleDictionary(salesPerson)

    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.

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