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
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"
Last edited by AB33; 10-11-2013 at 07:04 AM.
Hi strud: have you tried searching youtube? That helps me lot
//Peter
Originally Posted by strud
Peter,
I have not seen any clip on dictionary. If you know one, please send us the link.
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.
Yes, practice, practice and practice!
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:
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
Keys = dic.Keys .Range("g1:h1").Value = Array("Dictionary" & Chr(10) & "Employee", "Date") .Range("g2").Resize(dic.Count, 1).Value = Application.Transpose(Keys) For r = 0 To UBound(Keys) .Cells(r + 2, "h") = dic.Item(Keys(r)) Nextand how the following line works:R =0 To UBound
(I seem to remember you helped me with one of these codes before - but I may be wrong).Cells(r + 2, "h") = dic.Item(Keys(r))
Last edited by strud; 10-11-2013 at 07:19 AM.
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
It starts at 0 because keys are zero based arrays.R =0 To UBound
I am not entirely sure, but it may be you are loading(Copying) the items for each key..Cells(r + 2, "h") = dic.Item(Keys(r))
thanks for your help
(btw the code as in the article that's why I didn't post it)
To retrieve an item you use this syntax:
Because the code has already stored the keys in an array, you can refer to that array for the keyname:dic.Item(keyname)
Actually this is not necessary when you output all keys and all items:dic.Item(Keys(r))
should be sufficient without looping..Range("g2").Resize(dic.Count, 2).Value = Application.Transpose(Array(Keys, dic.items))
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks