My Excel VBA Master route

So far , I have also written a lot of more comprehensive management system (invoicing, personnel management, fixed Assets management, food and beverage management, etc.), to be honest, Excel VBA a lot of knowledge I do not know or useless, I Excel VBA The view is: to use, so point, learn so deep, laborious not?

many small partners want to learn VBA , but often insist on not to go on, feel things too special too much!! So, I have been working hard to refine, divide, and strive for more than 0 basic small partners can quickly and easily grasp this very tricky technology.

don't ask what is the difference between this and that? Don't ask me which is better with the writing and the writing? have been tangled in these differences, concepts, is never learn VBA , you just remember: this question, how to do?

Let's have a look . Excel VBA mastery of the road, you do not read wrong, is the "mastery" of the road. It means that you have mastered these things and you have enough of them.

====================== First Stage: Beginner, Programming Basics =======================

Reference Course: http://edu.51cto.com/course/course_id-1449.html

At this stage you need to master variables, procedures and functions, process controls, cells, worksheets, workbooks, arrays, dictionaries. Regardless of which module, do not care about the concept, the teacher said every instance of understanding, knocking out is enough! Finally, the course is based on a "Personnel management system" to consolidate the learning.

====================== Stage Two: Advanced, comprehend by analogy =======================

Reference Course: http://edu.51cto.com/course/course_id-6044.html

This stage has the following arrangement: Forms, controls, Xml read/write, class module, file operation, encapsulation. All in one instance to show, this stage of our goal is to learn to do the interface, packaging.

====================== Phase III: SQL , database development =======================

Reference Course: http://edu.51cto.com/course/course_id-3580.html

Excel with a lot of small partners have encountered a headache problem, is the amount of data is very helpless. So, using Excel as a front-end display, with Access or SQL Server as a data warehouse, is more practical and atmospheric. This stage is so arranged, comprehensive and practical to explain the useof ADO ,SQL Statements of various writing, so as to truly proficient in VBA Techniques for manipulating databases. Don't forget, the last "Fixed Asset management system" can be a good reflection of your degree of mastery.

I will be so much, I dare say I am proficient!

650) this.width=650; "Width=" "height=" "title=" Img_1738.png "style=" width:220px;height:220px; "src="/http S4.51cto.com/wyfs02/m01/8a/c4/wkiol1g72gzximrlaanoaygt7ig184.png-wh_500x0-wm_3-wmp_4-s_3331499083.png "Border=" 0 "vspace=" 0 "hspace=" 0 "alt=" wkiol1g72gzximrlaanoaygt7ig184.png-wh_50 "/>

This article is from the "Old Altar Sauerkraut" blog, please be sure to keep this source http://tank008.blog.51cto.com/8963545/1877334

My Excel VBA Master route