• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

What Is "Collections" & "Dictionary" ? what it's use In Excel VBA?

Here's more info.

Dictionary, Array, Queue, Stack, SortedList
http://analystcave.com/excel-vba-dictionary-arrays-and-other-data-structures/

Collection
http://analystcave.com/vba-collection/

As side note. Collection is native to VBA and does not require external reference, and thus, will work on Windows or MAC machine. Where as Dictionary is provided by COM libraries and will work on Windows machine only.

To use Dictionary on MAC, you'd need to write your own class module or use one available in GitHub.

https://github.com/VBA-tools/VBA-Dictionary
 
Chihiro said:
Here's more info.

Dictionary, Array, Queue, Stack, SortedList
http://analystcave.com/excel-vba-dictionary-arrays-and-other-data-structures/

Collection
http://analystcave.com/vba-collection/

As side note. Collection is native to VBA and does not require external reference, and thus, will work on Windows or MAC machine. Where as Dictionary is provided by COM libraries and will work on Windows machine only.

To use Dictionary on MAC, you'd need to write your own class module or use one available in GitHub.

https://github.com/VBA-tools/VBA-Dictionary
Click to expand...
Dear Sir Chihiro

Many thanks for giving hint.. for we can understand this things better.
this Organisation not just solve your particular problem of Excel VBA but also
try to hint what is the things behind the code & how it use in particular problems..

I Hope your hint should most helpful for every users...

Regards,

Chirag Raval
 
You must log in or register to reply here.
Back
Top