Excel2003 macros and VBA language

I'm going to recommend two good books, you can take a look.

The first "Excel 2003 Advanced VBA Programming Manual" book is a monograph written specifically for using VBA programming in Excel 2003, this book is the internationally renowned author John Walkenbach who enjoys the reputation of MR Spreadsheet, following the best-selling books such as "Excel 2003 Formula and Function Application Manual", "Chinese Excel 2003 Dictionary" and "Excel Application Skills Dictionary". It can be used as the first choice book for Excel users with certain experience to learn VBA programming, and it is also a very good reference book for advanced Excel programmers to go deep into VBA programming.

The second book, "Excel 2003 and VBA Programming from Beginner to Mastery (Chinese Edition)" Excel is a widely used electronic data ** program, and there will be many opportunities to develop valuable applications using VBA (Visual Basic for Application) programming in Excel. This book shows how to use VBA to develop Excel-based applications. To be proficient in Excel development, you need to develop your own generic assemblies or blocks.

The author uses his own development experience to add a large number of practical examples to help readers develop their own general programs. With these pre-established foundations, readers can create a large number of applications with very little time and effort.

In excel, in order to improve work efficiency and have to carry out **, this time it involves macro programming, the following is the content I brought about excel 2010 macro programming tutorial, welcome to read!

Excel 2010 Macro Programming TutorialExcel 2010 Macro Programming Tutorial 1:First, I've built a demo example. The function to be implemented in this article through macros is to place column a","The text before the number is extracted.

Excel 2010 Macro Programming Tutorial Figure 1Excel 2010 Macro Programming Tutorial 2:Right-click in sheet1 and select View.

Excel 2010 Macro Programming Tutorial Figure 2Excel 2010 Macro Programming Tutorial 3:The VBA page is displayed.

Excel 2010 Macro Programming Tutorial Figure 3Excel 2010 Macro Programming Tutorial 4:

end sub

Excel 2010 Macro Programming Tutorial Figure 4Excel 2010 Macro Programming Tutorial 5:Click Save when the input is complete, and click Yes in the pop-up dialog box.

Excel 2010 Macro Programming Tutorial Figure 5Excel 2010 Macro Programming Tutorial 6:Then a dialog box pops up, click OK to go down. In fact, these two steps can be set up to avoid popping up prompts, which I will share with you in the future experience.

Excel 2010 Macro Programming Tutorial Figure 6Excel 2010 Macro Programming Tutorial 7:Then click on View-Macro.

Excel 2010 Macro Programming Tutorial Figure 7Excel 2010 Macro Programming Tutorial 8:Select View macros.

Excel 2010 Macro Programming Tutorial Figure 8Excel 2010 Macro Programming Tutorial 9:Select the macro you want to execute from the list of macros, and then click Execute.

Excel 2010 Macro Programming Tutorial Figure 9

1. Macro is actually written by VBA, but you can make a macro by recording it, and you can view the corresponding VBA statement of the macro that you can do, so as to send it to learn VBA, as for which one to learn first, I personally think that macro is what everyone will, basically no need to learn, VBA must be learned.

2. You don't need to start with VB to learn VBA.

3. Excel and Access are both Office programs, and macro and VBA are one of the functions of these programs, Excel and Access have macro and VBA, through macro and VBA, Excel and Access and other Office software can have some programming functions, so as to complete more complex applications.

Macros: VisualBasic is a general-purpose programming language for developing application software in the Windows environment, which is powerful and easy to use. VisualBasic is a powerful and easy-to-use programming language for developing application software in the Windows environment.

VBA is a subset of it that can be widely used in various software developed by Microsoft companies, such as Word, Excel, Access, etc.

VBA: VisualBasicForApplications (VBA) is a macro language of VisualBasic, a programming language developed by Microsoft to perform general-purpose automation (OLE) tasks in its desktop applications. It can be used to extend the functionality of Windows applications, especially Microsoft Office software.

It can also be said to be a basic script for application visualization. The language was developed in 1993 by Microsoft Corporation and applications share a common automation language--- VisualBasicForApplication (VBA), which is actually a version of a parasitic VB application. In the 1994 version released by Microsoft, it had the macro function of VBA.

Excel has basic resources such as **, formulas, functions and many functions, for many ordinary users, mastering and using these functions can solve the problem. The use of VBA** can be replaced by the computer to carry out the corresponding operation, and the efficiency of VBA** operation is far greater than the manual operation of people, and the operation of personnel can be simplified at the same time, and the mistake of operation can be avoided. When some repetitive operation processes are often used, writing VBA can achieve very high work efficiency.

VBA is an important branch of the VB family, which is mainly used in Office software, especially in combination with Excel.

To use an analogy, excel is a rich son of a famous aristocratic family, well-educated and trained, not only extraordinary, but also has a lot of family resources. The VBA is a prodigy with some background, he came to the office with a skill, especially with Excel very well. So Excel worships VBA as the CEO, and hands over some complex and regular important affairs to it, and the resources are also called by it, and VBA really lives up to its expectations and handles things quickly and beautifully.

Macros are actually VBA programs.

VBA and VB are not the same.

VBA can also be used in access

Excel and Access are both part of the Office software.

What is a VBA macro, Visual Basic

Basic is a macro language that can be used to extend Windows applications.

features, especially Microsoft

Office software. It can also be said that it is a kind of application visualization in the Excel version released in the year, that is, it has the macro function of VBA.

What is an excel application.

Using Excel and VBA as platforms, the developed spreadsheet is called Excel application.

What is a Macro? A macro is a series of commands and functions that are stored in a Visual Basic module and can be run whenever you need to perform that task. If a task is repeated frequently, you can use macros to automate the task.

The above are the three concepts of VBA, so why use VBA?Why use Excel as a platform to develop programs?

Here are a few simple reasons!

1. When using Excel as a platform, your program can take advantage of the existing functions of Excel and can stand on the shoulders of a small giant, which can greatly reduce the development cycle.

2. Almost all computers have Excel, and a large number of people are using Excel, but not everyone will use VBA.

3. Excel development program distribution is very easy, as long as there is excel in the computer, there is basically no need to copy and paste in other files, and the distribution of files is completed.

4. VBA's language is relatively easy to learn language, easy to use, if you are familiar with VB, then you find that they are the same in terms of language, and if you know Excel better, then it is easy for you to understand Excel's various objects.

All the user's actions can be recorded and automatically converted into corresponding command descriptions.

Tools Raw Materials:

Lenovo Yangtian. windows7

excel2010

1. Open Excel and click Development Tools.

2. After that, click Record Macro.

3. The interface for recording a new macro will pop up.

4. Then enter 123 in **, then press the enter key, and then click to stop recording.

5. Then open another excel, and then click on macros.

6. On the pop-up interface, click Execute.

7. After that, the macro you just recorded will be executed.

Software version: Office 2013

The method is as follows: open the VBE interface, click the worksheet on the left side to execute **, and the blank area 2 on the right side appearsEnter **, click the Run button, or press F5:

3.In this way, the macro **:

Alt + F11 to enter the writing interface, and then write.

Alt + F11 to enter the writing interface, and then write. Go find a book and learn about it.