none
Dictionary questions in VBA RRS feed

  • Question

  • Hi

    I have a dictionary that has over 300 pairs in it. When I set a Watch to monitor the content it appears that that watch only displays the first  256? Is this a limitation or can the rest of the contents be displayed?

    Also, watch shows the Key value but not the content for each key - is there a way that this can be displayed.

    thanks

    peter

     

    Friday, July 8, 2016 2:14 PM

Answers

  • Any more questions?

    Andreas.

    • Marked as answer by py1 Wednesday, July 13, 2016 2:58 PM
    Wednesday, July 13, 2016 2:04 PM
  • thanks Andreas - that is great - I will try this.

    many thanks as always !

    Peter

    • Marked as answer by py1 Wednesday, July 13, 2016 2:58 PM
    Wednesday, July 13, 2016 2:58 PM

All replies

  • I have a dictionary that has over 300 pairs in it.

    What kind of dictionary?

    A Scripting.Dictionary from:

    Microsoft Scripting Runtime
    {420B2830-E718-11CF-893D-00A0C9054228}
    C:\Windows\SysWOW64\scrrun.dll

    Andreas.

    Friday, July 8, 2016 5:22 PM
  • Hi,

    This is the forum to discuss questions and feedback for Microsoft Excel, I'll move your question to the MSDN forum for Excel

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


    Regards,

    Emi Zhang
    TechNet Community Support


    Please mark the reply as an answer if you find it is helpful.

    If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Monday, July 11, 2016 9:01 AM
  • >>> When I set a Watch to monitor the content it appears that that watch only displays the first  256? Is this a limitation or can the rest of the contents be displayed?

    According to your description, this is a limitation, the Watch Window does not show more than 256 class objects in a collection. So I suggest that you could use Debug.Print and Immediate Window.

    In addition if you have any feedback for Excel, please feel free to submit them to User Voice:

    https://excel.uservoice.com/

    Thanks for your understanding.
    Tuesday, July 12, 2016 6:31 AM
  • Andreas

    yes - it is a scripting dictionary.

    thanks

    Peter

    Wednesday, July 13, 2016 8:01 AM
  • yes - it is a scripting dictionary.

    Hi Peter,

    as David said, it's a limit of the Watch Window.

    But you can use Dict.Items resp. Dict.Keys in the Watch Window to get the arrays, AFAIK there is no limit.

    If you have issues to get that into the Watch Window, get the array into a temporary variable and use it instead:
    Temp = Dict.Items

    Andreas.

    Wednesday, July 13, 2016 10:09 AM
  • Hi Andreas

    thanks for the reposne - but sorry I do not understand

    "But you can use Dict.Items resp. Dict.Keys in the Watch Window to get the arrays, AFAIK there is no limit"

    can you elaborate a bit please.

    many thanks

    Peter

    Wednesday, July 13, 2016 1:49 PM
  • Any more questions?

    Andreas.

    • Marked as answer by py1 Wednesday, July 13, 2016 2:58 PM
    Wednesday, July 13, 2016 2:04 PM
  • thanks Andreas - that is great - I will try this.

    many thanks as always !

    Peter

    • Marked as answer by py1 Wednesday, July 13, 2016 2:58 PM
    Wednesday, July 13, 2016 2:58 PM