• 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.

Learning Excel VBA

Hello Everyone,

Actually, I just want to ask you all perfect & extra ordinary talented people here in excel VBA that, what is easiest and an early way for learning the excel VBA. How much daily practice is required & what should be material, I should read & learn. If someone can guide me, please.

Actually, I can't afford the paid services but I have very keen interest in learning this. Please, Please tell me & guide me on this.

Thanks and Regards,
 

Chihiro

Excel Ninja
Microsoft VBA documentation for Excel 2013
https://www.microsoft.com/en-us/download/details.aspx?id=40326

Some tutorials.
http://www.excel-easy.com/vba.html
https://www.tutorialspoint.com/vba/
http://www.homeandlearn.org/
http://www.codematic.net/excel-development/excel-vba/excel-vba-best-practice.htm

I find that best way to learn was through trial and error. I hardly used any tutorial or books.

Browse through VBA forum, find a question you are interested in, and try to solve it. First, by using VBA reference only, then using Web Search. Compare your solution with those provided on the forum. Then, break apart provided solution (using break points, F8 to step through etc).

See below for Luke M's excellent post on various windows to track variables.
http://chandoo.org/forum/threads/immediate-window-locals-window-watch-window.25357/#post-151862

Last but not least, use Macro Recorder. It will give you starting point for automating many processes.
 
Thank you all for your valuable suggestions.

So Is it necessary to be perfect in Excel first then I should Move towards VBA? Because I have observed many functions can't work alone but if they combined with other functions/formulas they work like anything. So how can I learn this thing (Merging the functions/formulas with each other) ?

Any EXCEL learning related books or websites links?

Please share and guide me.

Thanks again for your valuable time guys!!!!
 

shrivallabha

Excel Ninja
It is important to understand that VBA is not limited to Excel only. So if you want to develop programming skills then you can start directly on VBA after understanding Excel object model basics.

On the other hand if you intend to develop your Excel skills along with Excel VBA to leverage maximum out of it then you should definitely spend more time in learning Excel's built-in features.

A simple example in this context which I have seen may clarify the point of view:
I have seen an LVLOOKUP user defined function defined in VBA since VLOOKUP doesn't look on the left. But if someone who knows how to use LOOKUP or INDEX+MATCH function, can easily do this without resorting to any UDF.

There's vast amount of knowledge on Excel on the web. Almost anything can be googled. I'd suggest you pick any book which offers content that you feel exciting and finish it.

Free advice :) :
It totally depends on your requirements and weightage you want to give to this activity. Be more inclined to "finish" than eager to "start". I have seen many people starting with vigor only to lose interest later.
 
Thank you, Shrivallabha:), Yes actually, I am very eager to learn & become an expert in excel VBA but was not getting the right path to start with. But when someone suggested me that Chandoo is the best platform to go with, So I came here & obviously I saw it here.
It amazed me so much that so many people respond very quickly to any query to solve in, which shows their talent.
And Yes I'm very much agree with your advice & will follow all of yours & others instructions in future to work with excel VBA.

One last question dear, I have seen people are using many functions all together like... =if(index(match(iserror(etc...etc....

This thing I don't know from where to learn, even I tried on web but
couldn't find it.

Like one functions returns the value to other then other one to another one. This thing I really like very much!

Please advice how people learn this thing & from where.

Thanks !!!!!:):):):):):)
 

shrivallabha

Excel Ninja
One last question dear, I have seen people are using many functions all together like... =if(index(match(iserror(etc...etc....

This thing I don't know from where to learn, even I tried on web but
couldn't find it.
There's no easy answer to this. Continuous usage of formula makes it intuitive somewhere down the line. Nothing will happen on the first day. Like in program you need understand individual statement or construct, you need to understand each individual function's way of working. To learn individual formulas you can try below link:
https://www.rondebruin.nl/efb/efb.htm

Go through following link for basic explanation of a nested function based formula:
http://spreadsheetpage.com/index.php/tip/creating_a_megaformula/
This is explained with several examples in John Walkenbach's book by name "Excel Bible".

There are several formula forensics articles on Chandoo which dissect such nested formulas. Almost all of them use such constructs to achieve the results. And they relate to some real life issues so it should benefit you well if you learn them.
http://chandoo.org/wp/formula-forensics-homepage/

Good luck!!!
 
Thank you so much sir! I have noted down all these links & will follow your instructions & guidance. Hope one day I will also be one of the expertise.

Thanks again for your kind support!
 
Top