Ebooka przeczytasz w aplikacjach Legimi na:
Odsłuch ebooka (TTS) dostępny w abonamencie „ebooki+audiobooki bez limitu” w aplikacji Legimi na:
Excel VBA Programming
Automating Excel through Visual Basic for Application
Copyright Steven Bright, 2018
This eBook is licensed for your personal enjoyment only. It may not be re-sold or given away to other people.
Also By Steven Bright
CorelDraw How: The Fundamental of CorelDRAW (CorelDRAW How Book 1)
Hypertext Markup Language (HTML) Fundamentals: How to Master HTML with Ease
Microsoft Office Productivity Pack: Microsoft Excel, Microsoft Word, and Microsoft PowerPoint
Microsoft Excel: Microsoft Excel User Interface, Excel Basics, Function, Database, Financial Analysis, Matrix, Statistical Analysis.
CorelDRAW Projects: Step by Step Professional Graphics Design Project Procedures in CorelDRAW (CorelDRAW How Book 2)
Master Cascading Style Sheets (CSS) Quickly: CSS Properties, CSS Property Definitions, Inline CSS, Internal CSS, External CSS and Sample Codes
Professions and Associated Computer Software: Get to Know the Software Programs your Profession requires you to have its Know-how
Microsoft PowerPoint: Creating a Presentation, Tips for Creating and Delivering an Effective Presentation, and Marketing Your Brand through PowerPoint Presentation
Computer Fundamentals: Introduction to Computer, Uses of Computer, Main Components of Computer, Input/Output Devices, Hardware/Software, Operating System, Internet, and More
Amazon Kindle Direct Publishing Complete Guide: Account Opening, Formatting, Cover Design, Publishing, Promotion/Marketing, Get US Payoneer Bank Account to Receive Your Royalties
Windows Operating System: Windows Operating System (OS) Installation, Basic Windows OS Operations, Disk Defragment, Disk Partitioning, Windows OS Upgrade, System Restore, and Disk Formatting
The ABC of eBook Publishing: Kindle Direct Publishing, Draft2Digital, Smashwords, Writing, Formatting, Creating an Active Table of Content, and Marketing Guide
Microsoft Word: Customizing the Quick Access Toolbox, Equations, Underline Styles, Insert Menu, Table, Page Layout, Formatting a Document, Edit Manuscript, and Preparation of an eBook for Publishing
Photoshop Beginner Guide: Photoshop Tools and their Functions, Photoshop Tools Practice, Color Management, File Formats, Photography, and Graphics Design
Visual Basic Application (VBA) For Excel Basics
Rules for Naming Procedures
VBA Macro Code
VBA Excel Object
Sub, Event and Function Procedures
UserForm and Button Procedure VBA Codes
Essentials of Visual Basic Programming
How to Create Excel Add-Ins
About the Author
Visual Basic for Application (VBA) is an Object Oriented Programming (OOP) language. This implies that VBA Excel is used to manipulate Objects contained in Microsoft Excel. These Excel Objects are listed below:
Application Object (Excel)
Worksheet Object ( Range Object, Name Object, etc.)
VBA Excel Environment
The main components of VBA Excel Software Environment are as follows: Note that you can refer to the image of the VBA Excel Software Environment below to best understand the identification of its different components.
Menus: This contains VBA Excel Software Environment menu options.
Standard Toolbar: This mainly contains shortcuts to VBA Excel commands.
Project Widow: This is where the name of the VBA projects in an active Workbook will be displayed alongside all the Excel Objects (Sheet1, Sheet2, Sheet3, ThisWorkbook).
Properties Widow: This is where properties of the selected Worksheet, Module, or UserForm is displayed and from where you can modify such properties.
Programming Widow: This is where an inserted Module or UserForm will be docked and opened so that macro codes can be written in it or paste into it.
The following are VBA Excel basics which if well understood will ensure a good foundation for the remaining sections of this book.
Save a Workbook as a Macro-Enable Document
To be able to record and execute macros in an Excel Workbook, you have to first save it as Macro-Enabled document. To do this, follow these steps:
Click on the “Office Button” on the top-left of Microsoft Excel.
Point to “Save As” and click on “Excel Macro-Enabled Workbook”.
Input the name for the workbook.
Click the “Save” button.
Fix Macro Disabled Error
When you open a macro-Enabled Workbook, you might receive a security warning at the top of the active Worksheet that “Macros have been disabled”. For you to be able to edit an existing macro in that Workbook or execute it, you must first fix this error. To fix it;
Click the “Options” button in front of the macro security warning message.
Select the option “Enable this content”.
Click the “OK” button.