Excel VBA 365 Made Easy

Liew Voon Kiong
Free sample

Excel VBA 365 Made Easy is a complete guide to mastering Excel VBA 365, for beginner to intermediate programmers. Authored by Dr. Liew, creator of the popular online Excel VBA Tutorial at excelvbatutor.com, this book is an excellent reference text for high school or college-level computer science courses. 

By the end of this book, you will gain a comprehensive understanding of basic Excel VBA 365 concepts and be able to create your own code from scratch. You will learn how to: 


1. Write code for objects like Worksheet, Range, Cells and more using their methods and properties

2. Write macros to automate tasks

3. Program code for all the ActiveX controls available in the Developer environment 

4. Create applications using the UserForm

5. Create objects and classes using the Class module


Best of all, you will gain inspiration from a variety of interesting examples like a calculator, stock trading program, slot machine, Star Wars, and more. You may modify the examples easily to suit your needs.



Read more
Collapse

About the author

Dr. Liew Voon Kiong holds a bachelor’s degree in Mathematics, a master’s degree in Management and a doctorate in Business Administration. He has been involved in Visual Basic programming for more than 30 years. He created the popular online Visual Basic Tutorial at www.vbtutor.net which has attracted millions of visitors since 1996. It has consistently been one of the highest ranked Visual Basic websites.

Dr. Liew is also the author of the Visual Basic Made Easy series, which includes Excel VBA Made Easy, Visual Basic 6 Made Easy, Visual Basic 2008 Made Easy, Visual Basic 2010 Made Easy, Visual Basic 2013 Made Easy, Visual Basic 2015 Made Easy, Visual Basic 2017 Made Easy and  Visual Basic 2019 Made Easy . Besides the VB books, he has also published JavaScript Made Easy, JavaScript & JQuery Made Easy and HTML & CSS Made Easy. Dr. Liew’s books have been used in high school and university computer science courses all over the world. 


Read more
Collapse
Loading…

Additional Information

Publisher
Liew Voon Kiong
Read more
Collapse
Published on
May 18, 2020
Read more
Collapse
Pages
405
Read more
Collapse
ISBN
9798642584767
Read more
Collapse
Read more
Collapse
Best For
Read more
Collapse
Language
English
Read more
Collapse
Genres
Computers / Desktop Applications / Suites
Computers / Programming / General
Computers / Programming / Microsoft
Computers / Programming Languages / Visual BASIC
Young Adult Nonfiction / Computers / Programming
Read more
Collapse
Content Protection
This content is DRM protected.
Read more
Collapse

Reading information

Smartphones and Tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and Computers

You can read books purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like the Sony eReader or Barnes & Noble Nook, you'll need to download a file and transfer it to your device. Please follow the detailed Help center instructions to transfer the files to supported eReaders.
Our 1000+ Object Oriented Programming Questions and Answers focuses on all areas of Object Oriented Programming subject covering 100+ topics in Object Oriented Programming. These topics are chosen from a collection of most authoritative and best reference books on Object Oriented Programming. One should spend 1 hour daily for 15 days to learn and assimilate Object Oriented Programming comprehensively. This way of systematic learning will prepare anyone easily towards Object Oriented Programming interviews, online tests, Examinations and Certifications.

Highlights

Ø  1000+ Basic and Hard Core High level Multiple Choice Questions & Answers in Object Oriented Programming with Explanations.

Ø  Prepare anyone easily towards Object Oriented Programming interviews, online tests, Government Examinations and certifications.

Ø  Every MCQ set focuses on a specific topic in Object Oriented Programming.

Ø  Specially designed for IBPS IT, SBI IT, RRB IT, GATE CSE, UGC NET CS, PROGRAMMER and other IT & Computer Science related Exams.

 

Who should Practice these Operating Systems Questions?

Ø  Anyone wishing to sharpen their skills on Object Oriented Programming.

Ø  Anyone preparing for aptitude test in Object Oriented Programming.

Ø  Anyone preparing for interviews (campus/off-campus interviews, walk-in interview and company interviews)

Ø  Anyone preparing for entrance examinations and other competitive examinations.

Ø  All – Experienced, Freshers and Students.

OOPs Basic Concepts -----------------------------------------------------------------------------7

Classes-----------------------------------------------------------------------------------------------11

Objects----------------------------------------------------------------------------------------------15

OOPs Features-------------------------------------------------------------------------------------19

Polymorphism -------------------------------------------------------------------------------------23

Encapsulation--------------------------------------------------------------------------------------29

Abstraction-----------------------------------------------------------------------------------------34

Constructors ---------------------------------------------------------------------------------------38

Types of Constructors----------------------------------------------------------------------------43

Copy Constructor---------------------------------------------------------------------------------48

Overloading Constructors-----------------------------------------------------------------------52

Execution of Constructor or Destructor ----------------------------------------------------57

Destructors-----------------------------------------------------------------------------------------61

Access Specifiers- --------------------------------------------------------------------------------66

Private Access Specifiers -----------------------------------------------------------------------70

Protected Access Specifiers--------------------------------------------------------------------76

Public Access Specifier --------------------------------------------------------------------------82

Data Members ------------------------------------------------------------------------------------87

Member Functions-------------------------------------------------------------------------------91

Local Class------------------------------------------------------------------------------------------95

Nested Class ---------------------------------------------------------------------------------------99

Passing and Returning Object with Functions--------------------------------------------104

Object Reference--------------------------------------------------------------------------------109

Memory Allocation of Object-----------------------------------------------------------------114

Object Use-----------------------------------------------------------------------------------------124

Abstract Class-------------------------------------------------------------------------------------128

Template Class------------------------------------------------------------------------------------132

Base Class------------------------------------------------------------------------------------------137

Derived Class--------------------------------------------------------------------------------------141

Class Use ------------------------------------------------------------------------------------------145

Inheritance----------------------------------------------------------------------------------------149

Types of Inheritance----------------------------------------------------------------------------153

Single Level Inheritance------------------------------------------------------------------------158

Multilevel Inheritance--------------------------------------------------------------------------164

Multiple Inheritance----------------------------------------------------------------------------169

Hierarchical Inheritance------------------------------------------------------------------------178

Virtual Functions --------------------------------------------------------------------------------182

Abstract Function--------------------------------------------------------------------------------186

Types of Member Functions------------------------------------------------------------------190

Member Operator Function------------------------------------------------------------------194

Overloading Member Functions-------------------------------------------------------------199

Overriding Member Functions---------------------------------------------------------------204

Constant Member Functions-----------------------------------------------------------------209

Private Member Functions--------------------------------------------------------------------213

Public Member Functions --------------------------------------------------------------------217

Exception Handling-----------------------------------------------------------------------------222

Catching Class Types---------------------------------------------------------------------------227

Static Data Members---------------------------------------------------------------------------231

Static Member Functions---------------------------------------------------------------------236

Passing Object to Functions------------------------------------------------------------------240

Returning Objects-------------------------------------------------------------------------------245

Assigning Objects -------------------------------------------------------------------------------249

Pointer to Objects-------------------------------------------------------------------------------254

This Pointer---------------------------------------------------------------------------------------259

Default Arguments------------------------------------------------------------------------------263

Constructors Overloading---------------------------------------------------------------------267

Upcasting------------------------------------------------------------------------------------------271

Downcasting--------------------------------------------------------------------------------------276

New Operator------------------------------------------------------------------------------------280

Delete Operator----------------------------------------------------------------------------------284

Automatic Variable------------------------------------------------------------------------------288

Extern Variable ----------------------------------------------------------------------------------292

Inbuilt Classes------------------------------------------------------------------------------------297

IO Class --------------------------------------------------------------------------------------------301

String Class----------------------------------------------------------------------------------------305


©2020 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.