Dissect and Learn Excel® VBA in 24 Hours: Changing workbook appearance - Softcover

HockSang, Liaw

Softcover

ISBN 10: 1542793238 ISBN 13: 9781542793230

Publisher: CreateSpace Independent Publishing Platform, 2017

Synopsis

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. And knowing them, you can easily understand the programs written by others and adopt into your programs the ideas and the VBA code that are presented in those programs.

Dissect and Learn Excel VBA in 24 Hours is a series of quick references to VBA code 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.Book 1: Changing workbook appearance focuses on changing the appearances of the worksheet cells, the worksheets of a workbook, the row and column headings, the sheet tabs, the layout view of a worksheet, the status bar, the formula bar, the Ribbon, and the Cell context menu.

The main purpose of changing the appearance is to let the users to have a better working experience when they are using your program. To facilitate the process of copying the code in the book and pasting it into VBE and Custom UI Editor, you may download the code from drive.google.com/file/d/0ByKhn-UYAjlQUTAtQTNoVVB6MTQ/view.

This book ends with a sample program that adopts most of the ideas that are discussed in the book. You may download the program for Excel 2010-2016 (drive.google.com/file/d/0ByKhn-UYAjlQZ1Bvb0JqVzVxVTg/view) to see how it changes the appearance of a workbook.

About this title

From the Author

There are three supplementary files for the book:

1. A file containing the VBA and XML code in the book

• It facilitates the process of copying the code in the book and pasting it into Visual Basic Editor (VBE) and Custom UI Editor.

2. The Mso Image browser

• It allows you to browse through thousands of predefined images and select a suitable image for your control.

3. The macro-enabled workbook for the sample program

• The program adopts most of the ideas discussed in the book in changing the appearance of a workbook. Following the descriptions in the book, you can see how it changes the appearances of some components in the workbook. The file is not password protected. You can study the VBA code and the XML code.

The URLs of the three files are stated in the book. Alternatively, you may visit the author's website at excelvbacode.wordpress.com.

Edition details

• Publisher: CreateSpace Independent Publishing Platform
• Publication date: 2017
• ISBN 10: 1542793238
• ISBN 13: 9781542793230
• Binding: Paperback
• Language: English
• Number of pages: 104