Using Dictionary in VBA scripting

Can someone help me with a reference or a link of a tutorial on how and when to understand the use of dictionaries in excel VBA scripting? I have seen lots of Excel Gurus use the dictionaries and I have tried to understand this methodology and when to use them.
If possible to include a code with comments on each line so that I can understand the use of the dictionary.
Examples of the dictionary scripting are as follows:

CreateObject("System.Collections.SortedList")
CreateObject("VBScript.RegExp")

Or if you know of any Excel book that explained this in details, please let me know also.

Hi,

help on MSDN site …

Thanks Norie, but do you have any reference that has lots of examples on the use of the dictionaries and also the ones below. I have seen lots of codes with these and I will like some explanations:

Please Login or Register  to view this content.

Norie, thanks for the references. I need to study them in details.

Take a look at snb's site for info on Dictionaries (and many other things)..

http://www.snb-vba.eu/VBA_Dictionary_en.html

apo, thanks for the link. It will really help me a lot. I appreciate it so much

Hi Apo,

Could you please suggest me the same level of tutorial for VBA Array.

Regards,
BS Singh