Dissect and Learn Excel® VBA in 24 Hours

No matter how complicated a program is, it is made of many smaller and tiny fundamental working parts of programming code. Each of them accomplishes a specific task. Some may just consist of only one or a few lines of code. Knowing the functions of these fundamental working parts, you can then easily write an unlimited number of working programs. Dissect and Learn Excel VBA in 24 Hours is a series of quick references for intermediate users who are looking for ideas...
More Description

No matter how complicated a program is, it is made of many smaller and tiny fundamental working parts of programming code. Each of them accomplishes a specific task. Some may just consist of only one or a few lines of code. Knowing the functions of these fundamental working parts, you can then easily write an unlimited number of working programs.


Dissect and Learn Excel VBA in 24 Hours is a series of quick references for intermediate users who are looking for ideas and samples of VBA code to accomplish certain tasks when they are in the process of writing a program.


In this series, you will see thousands of tiny working parts of VBA code that are used to accomplish many simple and yet meaningful tasks. To add a new workbook, to auto-fill a range, to sort a table of data, to generate a table of contents for all chart sheets and worksheets in a workbook, to loop through and manipulate a folder of Excel files, to place a control on the Ribbon, to send an email, and to login to an account in the Internet are some examples of these tiny working parts.


I hope this series of books will serve as quick references in facilitating you to write an unlimited number of working VBA programs. Let Excel VBA work for you.


Book 4: Working with controls and automation focuses on using Form controls and ActiveX controls on worksheets, controls on UserForms, and using automation to control Microsoft Word, Microsoft Outlook, and Microsoft Internet Explorer from Excel.


Adding controls to a worksheet and a UserForm, creating a Word document using values stored in a worksheet, sending emails with a file attached via Outlook to list of recipients stored in a worksheet, entering some text in a text box and clicking a command button on a web page via Internet Explorer are some of examples of automation.


The previous three books in the series discuss changing workbook appearance, working with worksheet ranges, and working worksheets, workbooks and files for Windows. This forth book, which is the last book in the series, discusses controls and automation.


If you are new to Excel, you may refer to my earlier book entitled Learn Microsoft® Excel® 2010 and 2013 for Windows® in 24 Hours. If you are new to Excel VBA, you may refer to another book entitled Learn Excel® VBA in 24 Hours - A quick reference for beginners.


You can download the related code file(s) from https://drive.google.com/drive/folders/1Qbw5BWFD3f9w2pM_pDa_CVyeHIKXTkEV?usp=sharing