+ Reply to Thread
Results 1 to 2 of 2

Can a dictionary key hold more than one item?

Hybrid View

  1. #1
    Registered User
    Join Date
    09-15-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    56

    Can a dictionary key hold more than one item?

    would like to store multiple items onto one key, eg.

    if dict.exists(Person.ID) then
      range("A2") = Person.Name
      range("B2") = Person.Gender
      range("C2") = Person.Weight
      range("D2") = Person.Height
    end if

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,088

    Re: Can a dictionary key hold more than one item?

    You can concatenate ( with a separator ) the values into one Item or use an array for the Item
    Last edited by PCI; 05-17-2015 at 04:45 AM.
    - Battle without fear gives no glory - Just try

+ 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] If dictionary key exists add new item to existing item array
    By strud in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-25-2014, 01:54 PM
  3. [SOLVED] accesing class members of an object returned by dictionary item
    By vientito in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2014, 05:08 PM
  4. Remove All Instances Of Key Item Pairs From Dictionary
    By goss in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-31-2013, 12:37 AM
  5. 2 Dimentional Array as Dictionary Item
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-05-2011, 11:13 AM

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