Looking for online learning materials on arrays & scripting dictionaries

[strud]

Helpful forum users have provided with me some useful codes using arrays and scripting dictionaries which I have been editing.

However, they are becoming so useful that I think I should start looking into them in more detail.

The materials I have found so far seem to assume quite a lot of previous knowledge- so resources that build up from the relative basics would be useful.

Thanks guys

[AB33]

Strud,
Yes, that was the issue I faced when I begun searching for script material.
scripting dictionaries are not part of excel. I have not come across a book which is specifically focus on script.
I had to gather small pieces of info from different sources.
The link is very good.
http://www.experts-exchange.com/Soft...ss-in-VBA.html
IMO, I had spent lots of time to understand dictionary without the solid grasp of arrays, was not good idea, but only with the wonderful world of "Hindsight!.
Dictionary are sometimes referred by the name of "Associative Array" Which means the key is associate with the Item.
There are many similarities and differences between dic and arrays, but the good starting point is "Arrays"

[lelkes]

Hi strud: have you tried searching youtube? That helps me lot
//Peter

Helpful forum users have provided with me some useful codes using arrays and scripting dictionaries which I have been editing.

However, they are becoming so useful that I think I should start looking into them in more detail.

The materials I have found so far seem to assume quite a lot of previous knowledge- so resources that build up from the relative basics would be useful.

Thanks guys

[AB33]

Peter,
I have not seen any clip on dictionary. If you know one, please send us the link.

[strud]

I couldn't find anything on youtube about it either.

Thanks AB33, the article you posted was fantastic for getting to grips with it.

I keep finding that I can read an example or see some code and think I understand how that works (after some examination) but it is writing my own that becomes much more difficult.

Just practice I guess. You were right as well it all comes back to arrays in this instance really.

[AB33]

Yes, practice, practice and practice!

[strud]

related to that article AB33 I was wandering whether you might answer a question I have on an example in it....

In example #4 in the article- the last bit of the code to write the dictionary items to the worksheet is:

Please Login or Register  to view this content.

I understand the first bit and how that deals with the keys. I am not 100% sure on how the bit dealing with the dic.Items works...specifically why it is

Please Login or Register  to view this content.

and how the following line works:

Please Login or Register  to view this content.

(I seem to remember you helped me with one of these codes before - but I may be wrong)

[AB33]

I do not know with out seeing the code with attached sheet, but I guess

Keys = dic.Keys

Loads the keys in to another variable "Keys".
It is a word I would not use to load the keys array as it confuses the keys with another key.

As the keys have lots of values (In an array), you need to loop through the array

Please Login or Register  to view this content.

It starts at 0 because keys are zero based arrays.

Please Login or Register  to view this content.

I am not entirely sure, but it may be you are loading(Copying) the items for each key.

[strud]

thanks for your help

(btw the code as in the article that's why I didn't post it)

[Izandol]

To retrieve an item you use this syntax:

Please Login or Register  to view this content.

Because the code has already stored the keys in an array, you can refer to that array for the keyname:

Please Login or Register  to view this content.

Actually this is not necessary when you output all keys and all items:

Please Login or Register  to view this content.

should be sufficient without looping.

[strud]

Thanks Izandol- yeah I was getting confused as to why a loop was used.

Just tried your way without and that works great.

Thanks for the help