• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recommendations for learning Macros and VBA

adamuce

Member
Hi Guys,

I know there are tonnes of material out there but was looking for recommendations.

I have tried doing excel tutorials but I find it rather complex. I would like some recommendations for a place which is much simpler.

Thanks in advance
 
Hi !

As tutorials are often the best way to learn …
As it is just about reading …
Compare tutorials or forums' code with the VBA inner help.

Another way : activate the Macro Recorder and operate manually
with Excel inner features : you will get a code base.
Then for each unknown code keyword, see in the VBA inner help …
Compare also this generated code with tutorials
or solutions in forums in order to learn how to optimize it
to avoid any not necessary stuff like Activate, Select, …
which slow down the execution.

The more you will know Excel, the more easier your VBA codes will be …
 
Thanks for your reply and advice. MS Excel's tutorial on VBA was not very easy for me to understand, although MS Excel's tutorials on formulas I have used in the past.
 
Thanks again for your prompt response. I was looking for even more basic than that. I have no idea what those things mean. However once I get the basics I think I can progress onto such things. :D
 
First for any VBA need, respect the main TEBV rule :
Think Excel Before VBA !
Just asking yourself : « What Excel can do for me ? »
As sometimes just with Excel basics a code is even not really needed …

I already met algorhithmic VBA codes needing a very long time to execute
as they didn't follow any Excel logic (its basics / inner features)
but just operating manually Excel basics it needed just a few seconds !
So a procedure reproducing the same way is far faster to execute
and easier to maintain …

What is the best code ?
The one you first are able to understand and to maintain !
But before it needs reading, practicing, reading & practicing again …
 
Thanks for your reply. Just downloaded a guide. Will look into it

If you register there you will get an email in regards to the weekly webinar's, which aren't always weekly.

This is a huge resource of high quality material with real life examples
 
Dear all,

Strait forward & effactive stream of knowledge to
Understand this thing may be near cover all possible aspect of
Excel VBA is here www.globaliconnect.com.

Repeat reading about same concept about Object, Property & Method's,
loops ,Statements,Arrays,,Collections,and many more basic
become helpful on stay & increase understanding & knowledge in mind.

I refer videos on wiseowl.com about Excel VBA
Its Spread more knowledge in mind about how to thing works practically
Is very helpful if repeated viewing with concentration.repetation explore
More & more knowledge about any concept.

Hope this will helpful.

Regards

Chirag Raval
 
Back
Top