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

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

ARS NETWORK (M) SDN BHD  ❘ Freeware
iOS
out of 64 votes
Latest Version
1.1.0
Safe to install
EXCELLENT User Rating

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
  2. 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
  3. Chapter 2: Working with functions and procedures
  4. 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
  5. Chapter 3: Getting started with VBA programming
  6. 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
  7. Chapter 4: Manipulating Excel cells
  8. 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
  9. Chapter 5: Working with Excel VBA functions
  10. 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 >
  11. Chapter 6: Conditional statements and loops
  12. If statement Goto statement Select Case statement For...Next loop For Each statement IsNumeric function Do...While loop
  13. Chapter 7: Events
  14. 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
  15. Chapter 8: Identifying and fixing errors
  16. 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 >
  17. Chapter 9: User interaction
  18. 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 >
  19. Chapter 10: Working with other form controls (1)
  20. 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
  21. Chapter 11: Working with other form controls (2)
  22. Tab control Selecting a range of cells by the user with RefEdit Slider or Scroll Bar control Spin control

Overview

Learning for VBA in Excel آموزش به زبان فارسی is a Freeware software in the category Education developed by ARS NETWORK (M) SDN BHD.

The latest version of Learning for VBA in Excel آموزش به زبان فارسی is 1.1.0, released on 01/25/2024. It was initially added to our database on 01/25/2024.

Learning for VBA in Excel آموزش به زبان فارسی runs on the following operating systems: iOS.

Users of Learning for VBA in Excel آموزش به زبان فارسی gave it a rating of 5 out of 5 stars.

Screenshots (Click to view larger)

Related


CPA Exam Prep - mi. Accounting

For individuals seeking an introduction to the field of accounting but feeling uncertain about where to start, this application serves as a practical and accessible tool.

English to Persian Translator

Accurate and User-Friendly English to Persian Translation Tool

Erfan Halgheh TV

This app provides users with the ability to watch the live broadcast of Erfan Halgheh TV. It is an online streaming platform designed specifically for fans of Erfan Halgheh TV to conveniently access the content on their iOS devices.

Farsi Dic

Ultimate Fast and Powerful Dictionary English - Persian (Farsi) Persian - English Farsi Dic is a comprehensive tool for looking up words in both Persian and English languages.

Functions. Excel&Google Sheets

Functions is an innovative, AI-driven learning platform designed to enhance practical spreadsheet skills in both Excel and Google Sheets.

Khmer Chinese Translator

Translator specializing in Khmer and Chinese languages, offering professional translation services. Features include: Support for input in Khmer and Chinese through voice Translation of words and sentences Text-to-speech …
Secure and free downloads checked by UpdateStar

Stay up-to-date
with UpdateStar freeware.

Latest Reviews

DriverMax DriverMax
Enhance Your PC Performance with DriverMax
Grand Theft Auto IV v Grand Theft Auto IV v
Experience the Gritty Realism of Liberty City in Grand Theft Auto IV
K-Lite Codec Pack Full K-Lite Codec Pack Full
Enhance Your Media Experience with K-Lite Codec Pack Full!
Win10 PrivacyFix Win10 PrivacyFix
Protect Your Privacy on Windows 10 with Win10 PrivacyFix!
Assistente aggiornamento Windows Assistente aggiornamento Windows
Maximize your Windows updates with Assistente aggiornamento Windows!
Pulse Application Launcher Pulse Application Launcher
Boost Your Productivity with Pulse Application Launcher!
UpdateStar Premium Edition UpdateStar Premium Edition
Keeping Your Software Updated Has Never Been Easier with UpdateStar Premium Edition!
Microsoft Edge Microsoft Edge
A New Standard in Web Browsing
Google Chrome Google Chrome
Fast and Versatile Web Browser
Microsoft Visual C++ 2015 Redistributable Package Microsoft Visual C++ 2015 Redistributable Package
Boost your system performance with Microsoft Visual C++ 2015 Redistributable Package!
Microsoft Visual C++ 2010 Redistributable Microsoft Visual C++ 2010 Redistributable
Essential Component for Running Visual C++ Applications
Microsoft OneDrive Microsoft OneDrive
Streamline Your File Management with Microsoft OneDrive

Latest Updates


Auslogics Disk Defrag 12.0.1.2

Improve PC performance with Auslogics Disk Defrag!

xZoom - Camera Booster 1.1.213

The new Hybrid Zoom for your iPhone Camera ABOUT THE APP The xZoom.app was designed to achieve the maximum digital zoom performance. At the Concert Hall or at the Football Stadium, xZoom.app will not be superfluous.

Toka Life-Paris Fashion City 1.0

Embark on an immersive journey within Toka Life-Paris Fashion City, a vibrant virtual world that invites exploration and creativity. Take a plane and traverse the globe, experiencing a variety of engaging environments.

Purple Diamond Launcher Theme 3.7

The Purple Diamond theme offers high-definition wallpapers coupled with a collection of crystal-inspired icon packs. It includes an icon changer compatible with over 100 popular applications, enabling users to personalize their device’s …

MUM & DAD HAPPY BIRTHDAY 1.0

The concept of a "Mum Dad Birthday" typically refers to a special occasion dedicated to celebrating the birthdays of both parents within a family.

خطب الجمعة مكتوبة ومشكولة 11

This application offers a selection of properly formatted and concise Friday sermons, serving as a reliable resource for delivering khutbahs on Fridays.