Excel VBA Introduction Part 39 - Dictionaries

By Andrew Gould

[jeffreystockdale]

Best videos because, planned, and edited. No wasting time showing errors or typos like the other utube tutorials or waiting to think out the proper procedure, very well developed.

[gutolima]

Excelent teacher, I really admire your job and lessons.

[alexanderwohl]

To echo Kumar, it's been a great journey to learn VBA with you. I've watched all 39 videos up to this one. Thank you so much for this great resource.

[mikoajgerlich]

Thanks, It solved my problem connected with selecting tabs based on colour. Without watching your tutorial I would have never thought that it's possibility of adding sheets in precise colour to directories and next using it in string arrays (in my excel file each colour is responsible for diffrent type of data so it's really usufull for me, now I have simple way of selecting sheets which store specific type of data) .

[dpinched]

I'm REALLY enjoying the learning VBA series, please keep up the GREAT work! Thank you.

[terryk]

This is an excellent series! I have been programming in VBA for some time and I have still learned a lot from this series. Thank you so much!

[newspaper]

Wow, great tutorials. I know a little bit about Visual Basic Programming (Wrote a few small programs for my job) But i always wondered about VBA, you took a subject, and made it so very easy to understood. You make learning seem easy. I thank you very much for your videos. Great job!!!!

[nazaserh]

Great video. Simply amazing, as always.

[theRealMrdodgy]

Hi Andrew, thanks for the tutorials!
Your teaching method is great, very clear and easy to understand (and I have no problem with your accent!)
It would be great if you could build further on this video by elaborating retrieval of data from dictionaries based upon multiple criteria, looping, etc. in the most effective and efficient way.

[nikunjgattani]

Thanks a lot..Videos are very helpful... Do you have any video on doing look up using dictionaries.

[harishkumar]

Hi Andrew
It has been an awesome journey with you to learn VBA. I am all time fan of your.

With specific to this last video where you explains use of Dictionary.
I had a problem with the dictionary.items(z).tilte property, it throws run time error 424 Object requried. Imagining that I have defined all the variables as per my code, i could not find solution of this.

[micahneely]

If you make a few more on Charts and Graphs, I will like all your videos and pay you a dollar.

[wattjock]

I am pretty well versed in Excel and use it extensively but... I have decided to learn VBA in Excel for a very specific and personal project and am just now getting started learning. I greatly appreciate YouTube Channels such as yours for the Tutorials! I am going to have many questions and appreciate any answers that are provided.

Any reason why you would write "Dim MyFilms as New Collection"? Wouldn't doing that render the "Set MyFilms = New Collection" line unnecessary?

[emailuznow]

Hi Andrew,

I have searched everywhere on youtube but i cant find this anywhere. I have seen that class interface (implement) is really powerful.
Is there any chance you could do a video on
Class interface
Creating objects within objects
Working with windows Api's etc
That will complete the set on vba and i dont see any other examples like this
Hopefully you can
That would be awesome
Thanks

[chan]

I have heard that the fastest lookup way is by using dictionary.If I got a couple ten thousand items and I need to lookup for 5 values of the code(at the same row), in this case, how I add all items from another workbook into dictionary and keep it updated, and do I have do build 5 dictionary for that?

[jayamatuwani]

Hey the tutorial is quite good but i had one question how do i store a dynamic array into dictionary ?

[wattjock]

One other observation, after running the Code once... I re-start the Code (F8) and I see that the Dictionary is still full of Items until the Set line runs, at which time it resets the new Dictionary.

Will the dictionary stay in memory until it a new instance of the Dictionary is run or it is Set to Nothing? Will it reside in Memory even after the Workbook is closed?

[LilaBdrKarki-kbmn]

how to deal with the data when sheet is added to a dictionary, sir

[Myrslokstok]

I manage to loop out all the values out of my dictionary, but I can not retrieve the values by typing:

MyDictionary2 ("1234")

I have a similar myDictionary1 in another module that works prima nicely and that contains more advanced data.

I have tryed as a variable with different datatypes as string, integer, long or double. But the variable showes the same as the debug.print window, exept for the extra blankspace at the end but I even tryed to add that.

The key showes as 1234 in the debug.print window when looping over the key as a variant variable.

I do not get it.

It all worked so nice in myDictionary1 and not at all for myDictionary2 in the other module.

I go true the code with F8, and I can then see that the myDictionary2("1234") never works, it returns Empty.

[edtardaguila]

sometimes I am having difficulty of listening  and understanding of what was saying due to accent e.g beginning 16:36 sorry but no offense, but nonetheless the overall video was superb helpful to us
Thank you for this wonderful tutorial video