New'ish VBA Site

[Hui]

Hi All

Today I stumbled on Excel Macro Mastery
http://excelmacromastery.com/Blog/

It obviously deals with VBA and has excellent posts on all things VBA from beginners level through to Arrays, Collections & Dictionaries

Well worth a visit

 

[YasserKhalil]

Thanks a lot Mr. Hui for this great link .. It is like a treasure

 

[Hui]

It sure is!

 

[Marc L]

Hi !

I just took a glance at the beginning and I don't exactly agree with​

The Collection however, has two major faults

1. We cannot check if the key already exists.
2. We cannot change the value of an existing item.

Yes it's true directly …
But it's not difficult to create within a class its own properties
or functions to play with a Collection like a Dictionary object,
very useful for MAC as Dictionary object exists only under Windows …
(in fact it's a Windows object and not a VBA one !)
​

 

[Deepak]

Nice discovery!!!

 

[Khalid NGO]

Great site.

Bookmarked!

 

[mohadin]

Thanks