+ Reply to Thread
Results 1 to 6 of 6

Dictionary with 3 or more keys

  1. #1
    Forum Contributor
    Join Date
    04-21-2010
    Location
    Budapest
    MS-Off Ver
    Excel 2010
    Posts
    155

    Dictionary with 3 or more keys

    I have following code but I am not able to get the 2nd. and 3rd key based on the key value.
    Please help me to correct the code. I am a very beginner in programming so every support might be handy.

    Please Login or Register  to view this content.
    Last edited by ccsmith; 04-19-2018 at 02:06 PM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,070

    Re: Dictionary with 3 or more keys

    This will give you the name & e-mail for key 1
    Please Login or Register  to view this content.

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Dictionary with 3 or more keys

    Like this.
    Please Login or Register  to view this content.
    Edit: Ooops, should have pressed F5 before posting.
    My apologies Fluff13
    Last edited by bakerman2; 04-19-2018 at 01:23 PM.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,070

    Re: Dictionary with 3 or more keys

    Quote Originally Posted by bakerman2 View Post
    Edit: Ooops, should have pressed F5 before posting.
    My apologies Fluff13
    No worries, we've all been there

  5. #5
    Forum Contributor
    Join Date
    04-21-2010
    Location
    Budapest
    MS-Off Ver
    Excel 2010
    Posts
    155

    Re: Dictionary with 3 or more keys

    Thanks for everybody. It is working.

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,070

    Re: Dictionary with 3 or more keys

    Glad we could help & thanks for the feedback

+ 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. [SOLVED] Pass dictionary keys into stack object vba
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-09-2017, 04:06 AM
  2. [SOLVED] using keys of the dictionary
    By maroon1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-08-2016, 03:04 PM
  3. [SOLVED] How to compare keys in one dictionary to keys in another dictionary
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2015, 02:27 PM
  4. [SOLVED] Macro to write dictionary keys to array not working
    By capson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2015, 05:21 PM
  5. [SOLVED] Filter data using keys in dictionary
    By ATLGator in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2014, 11:48 PM
  6. [SOLVED] Transposing dictionary keys and items into one column
    By strud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2013, 09:42 AM
  7. [SOLVED] Problems retrieving keys as well as items when using scripting dictionary
    By strud in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-09-2013, 05:31 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