Learning for VBA in Excel آموزش به زبان فارسی 1.1.0

VBA, which stands for Visual Basic for Applications, is a type of programming language that allows you to use it in Office. In this instructional software, we focus on the application of VBA in Excel 2013.

Software Features:

• Ability to move text on the display screen
• Ability to delete displayed text
• Ability to repeat speech on pages
• Ability to set automatic or manual speech playback
• Ability to search in lists
• Compatibility with all iPhone and iPad models
• Ability to split the screen on iPad Pro and use simultaneously with other programs
• Display special notifications

List of contents provided in this software:

1. Chapter 1: Introduction to VBA and macros
Introduction to VBA What is a macro? Creating a macro for an Excel file Running a macro Viewing macro code Modifying macro code Creating a macro for Excel Adding macros to the Quick Access Toolbar Shortcut keys for macros and Excel Creating a sorting macro Create a button to run a macro Deleting the created button Create an image for running a macro
2. Chapter 2: Working with functions and procedures
Introduction to modules Creating a procedure Naming conventions for procedures Running a procedure Using modules in other projects Deleting a module Activating Option Explicit Ways to run a procedure Defining a function Ways to run a function User-defined functions
3. Chapter 3: Getting started with VBA programming
Adding comments to the program Defining a variable Determining the variable type Variable scope Defining a variable as public Static variables Defining a constant Excel and VBA default constants String and date variables Operators Arrays Two-dimensional arrays
4. Chapter 4: Manipulating Excel cells
Addressing Excel cells using the Range object Cells property Offset property Value property of a range An example to consider Text property Count property Font property Numeric display formats Inserting a formula in a cell using VBA RANGE object Activate method RANGE object Select method COPY and PASTE methods CLEAR methods and their types Delete method
5. Chapter 5: Working with Excel VBA functions
What is a function? Date functions in VBA </ li> < li > Modifying text with VBA functions </ li > < li > Len function </ li > < li > Left and Right functions </ li > < li > Mid and Replace functions </ li > < li > Using Worksheet functions </ li >
6. Chapter 6: Conditional statements and loops
If statement Goto statement Select Case statement For...Next loop For Each statement IsNumeric function Do...While loop
7. Chapter 7: Events
Identifying events Opening a Workbook event Closing a Workbook event Saving a Workbook event Activating a Sheet event Name property of the sheet object Deactivating a Sheet event Identifying double-click and right-click events Identifying right-click event Changing a WorkSheet event Moving scroll bar event
8. Chapter 8: Identifying and fixing errors
Checking an error </ li > < li > On Error GoTo structure </ li > < li > Ignoring errors with On Error Resume Next code </ li > < li > Identifying error names and codes </ li >
9. Chapter 9: User interaction
Displaying messages to the user with MsgBox </ li > < li > Receiving input from the user with InputBox </ li > < li > Selecting a range of cells using InputBox </ li > < li > Creating a form to get information from the user </ li > < li > Adding a label to a form </ li > < li > Changing the properties of a form </ li > < li > Adding a button to a form </ li > < li > Adding code to a form </ li >
10. Chapter 10: Working with other form controls (1)
Frame control OptionButton control Sorting the placement of controls Entering code for the form CheckBox control How to display text on a button Image tool Label control TextBox control
11. Chapter 11: Working with other form controls (2)
Tab control Selecting a range of cells by the user with RefEdit Slider or Scroll Bar control Spin control