최신 버전:
1.1.0 설치 하는 안전
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:
- 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
- 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
- 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
- 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
- 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 >
- Chapter 6: Conditional statements and loops If statement Goto statement Select Case statement For...Next loop For Each statement IsNumeric function Do...While loop
- 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
- 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 >
- 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 >
- 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
- 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
개요
Learning for VBA in Excel آموزش به زبان فارسی 범주 교육 ARS NETWORK (M) SDN BHD개발한에서 프리웨어 소프트웨어입니다.
Learning for VBA in Excel آموزش به زبان فارسی의 최신 버전은 2024-01-25에 발표 된 1.1.0. 처음 2024-01-25에 데이터베이스에 추가 되었습니다.
다음 운영 체제에서 실행 되는 Learning for VBA in Excel آموزش به زبان فارسی: iOS.
Learning for VBA in Excel آموزش به زبان فارسی 사용자 5 5 등급으로 평가 했다.
관련
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
This application serves as a functional and user-friendly translation tool, enabling users to translate words into English or Persian with ease.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 …최신 리뷰
![]() |
WinRAR
WinRAR을 사용한 효율적인 파일 압축 및 추출 |
![]() |
Internet Download Manager
인터넷 다운로드 관리자로 다운로드 속도를 높이십시오! |
![]() |
Mozilla Thunderbird
Mozilla Thunderbird를 사용하여 이메일을 쉽게 정리하세요! |
![]() |
K-Lite Codec Pack Full
K-Lite Codec Pack Full로 미디어 경험을 향상시키십시오! |
![]() |
UltraISO
모든 디스크 이미지 요구 사항을 충족하는 강력한 ISO 관리 도구 |
![]() |
Telegram Desktop
Telegram Desktop을 통한 안전한 메시징 및 파일 공유. |
![]() |
UpdateStar Premium Edition
UpdateStar Premium Edition으로 소프트웨어를 최신 상태로 유지하는 것이 그 어느 때보다 쉬워졌습니다! |
![]() |
Microsoft Edge
웹 브라우징의 새로운 표준 |
![]() |
Google Chrome
빠르고 다재다능한 웹 브라우저 |
![]() |
Microsoft Visual C++ 2015 Redistributable Package
Microsoft Visual C++ 2015 재배포 가능 패키지로 시스템 성능을 향상시키십시오! |
![]() |
Microsoft Visual C++ 2010 Redistributable
Visual C++ 응용 프로그램 실행을 위한 필수 구성 요소 |
![]() |
Microsoft OneDrive
Microsoft OneDrive로 파일 관리 간소화 |