How to install Code VBA Free Edition? Code VBA graphic tutorial

Code VBA free version installation tutorial! Code VBA is a knowledge and productivity plug-in that allows professional software developers and MS Office users to write VBA Code faster and spend less time looking for solutions online. Today's script home Xiaobian to share with you is the Code VBA free version of the installation tutorial, I hope this tutorial can help you!

Install free tutorial

1. After downloading and decompressing the script home, you will get files such as codevbasetup.msi and crack, double-click codevbasetup.msi to install the software, as shown in the figure

2. Click browse to replace the software installation directory, as shown in the figure

3. Proceed to next, as shown in the figure

4. Wait until the installation is complete, as shown in the figure

5. The installation is complete. As shown in the figure

6. Do not run the software first, copy codevba.dll in crack folder to \Code VBA folder in the software installation directory for replacement, as shown in the figure

7. Select the file in the replacement target, as shown in the figure

Instructions for use:

Code VBA Works with MS Access, Excel, Word, Outlook, PowerPoint, Publisher, MS Project, Visio, and AutoCad. Office 2010-2019 and 365 32-bit and 64-bit versions; windows7 and windows10

Main function

• Context-sensitive IntelliSense allows you to select a code from a shortcut menu. Here, you can use an existing variable or constant or declare a new variable, select from an existing name, get an attribute value, or call a VBA function that will return a value of the desired type. In the case of the Set(ting) object variable, it displays all possible sources for you to choose from. When you need to specify a condition, it allows you to use the choices above that return booleans and condition generators.
• Starting with Object, the cascade menu moves you down to the application's object model to apply the required actions: set properties, launch methods, loop collections, and so on.
• Tooltips explain what classes and procedures do and provide direct access to Office MSDN online related documentation (F1). If it is a property of an available object, the actual value is also displayed.
• Learn what they do by trying them out in the immediate window before including them in your macro.
• The application menu provides shortcuts to the most commonly used tools, such as Excel and Access.
• Includes many generators: class generators, user form generators, procedure generators, loop generators, If/Select generators, condition generators, string generators, message box generators, input box generators, select box generators, date picker generators, variable/constant generators, enumeration generators. Specifically for MS Access: Recordset BuilderS(DAO and ADO), Create Class for Table, and SQL VBA Builder.
• Use Code Explorer instead of Project Explorer: easily navigate to procedures, comment code, make neat indents, add error handling, export modules to code snippet libraries.
• Extend the Code VBA library with your own online code snippets and resources.
• The procedure call builder provides meaning to the parameters of each procedure. For each parameter, you can choose from an appropriate enumeration, object, or variable.
• Use automation to make Office applications work together, such as custom email (Outlook) from Access databases. References are set automatically and support early and late binding.
• Add new features regularly. The latest addition is the HTML writer.

Software feature

1. Write lines and complete blocks of code using proper syntax.

2. Find and insert VBA for Excel, Access, and Word from the menu organized according to the application object model.

3. Tooltips explain what classes and procedures do and provide direct access to Office MSDN online related documentation (F1).

4. The procedure call generator displays the meaning of each procedure parameter. For each parameter, you can choose from an appropriate enumeration, object, or variable.

5, the code browser, you can navigate to the program quickly and adds many practical features such as insert procedure calls with parameters, test the program from the instant window, comment the code and tidy code indentation.

6, The Class Builder and User Forms Builder helps you create custom classes and user forms custom dialogs with validation quickly and easily.

7. Extend the Code VBA library with your own code snippets and online resources.

Software description

1, code navigation, etc

The code browser follows links to display all programs in the project and allows you to move to the work you need as soon as possible with a double-click selection process. In addition, it lets you choose to insert into the program code, comment the code in the current location, select or delete the program, tidy code indentation, drag the program to other modules (moves) or items (copies) and more.

2, code VBA menu

The following demonstration follows the flow of the code VBA menu added to the visual development environment. The menu starts with the "Code VBA" item in the toolbar, and the start of the truncation menu can be seen in the image below. Keyboard users will benefit from the ability to select appropriate menu items using Alt key combinations. For example, Alt-CPFB inserts a piece of code for a new function whose return type is "Boolean."

To the right of "Code VBA" is a submenu for the copy main area. This makes it take less time to open the correct menu: Alt-PFB

Note: If the toolbar does not appear, it may be due to Windows Explorer opening excel in the preview pane, or it may be caused by an antivirus program. You can try to fix this by closing the preview pane or opening Excel before opening the file you want to work on.

3. Control structure

Insert blocks of code, such as If... Then .. Else .. End If or For Each... Next is certainly nothing special, but because they come up so often it will save you time. In my s? The menu displays built-in expressions such as ISNULL and IsEmpty and is included when used if you forgot the tutorial.

Conditional statement -I f and S selections

Isi list

Repeat statements -Do and F or loop

OTO and GoSub. GoTo displays a list of tags available in the current process (if any), and you can indicate where to jump to.

4. User interaction

This allows you to choose from built-in dialogs and some additional custom dialogs. All relevant code and processing is inserted at once.

There are many uses for automatically adding a message box with an appropriate Select Case statement

An InputBox extension with code to verify that the type of the value is correct

New selection box dialog box for simple (or multiple) selections from a list (AKO input box)

New DatePicker dialog box for simple and user-friendly selection of dates or start and end dates (AKO input box)

File selection Open and save

Userform Builder - Form code includes input validation

All important Excel built-in dialogs (if applicable)

The above is the script home Xiaobian to share the Code VBA free version of the installation tutorial, this tutorial is effective, everyone rest assured to use!

Latest comments