Use recording macros, VBA Help, and network search

Source: Internet
Author: User

In the final section of VBA learning, I would like to emphasize that to make good use of recording macros, Excel's Help and network search.

In the process of self-study VBA, I often say to use more-learn-think-more and Beginners self-study VBA also three big tools: Recording macros, VBA Help and network search. Make good use of these three kinds of words, many problems do not need the help of others can solve their own.

1, record the macro. From a tool/macro/Record New macro, you can convert the action before you stop recording the macro into VBA code. This allows you to record a macro without any knowledge of VBA. But recorded macros have limitations, but can be modified and processed to make the recorded code more complete. Recording macros can also be done to understand the object and method of Excel, as the initial learning of VBA, is a good way to learn and good assistants.

2, VBA Help. VBA Help includes descriptions of all of the attributes, objects, methods, and so on in Excel, and it is helpful to learn about all of the properties, objects, and methods of Excel by frequently reviewing VBA help in the process of learning VBA. In view of other people's Code, the unfamiliar word, as long as the cursor moved to it, and then press the F1 key, you can quickly detect the relevant help. In the Help Answer Wizard, we can also type in the relevant keywords to find what we need. When you can skillfully apply good help, your VBA level can be said to have taken a step.

3, the network search. The advantage of the network is the huge amount of information, and to find out what we need, the most basic is to use good search. Commonly used search such as Baidu, Google, etc., as long as the correct and reasonable type of keywords, you can find a lot of relevant information. And in a site, also often have their own site search, then use search can let us faster and easier to find the information we need.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.