Жанры
Авторы
Контакты
О сайте
Книжные новинки
Популярные книги
Найти
Главная
Авторы
Dick Kusleika
Excel VBA Programming For Dummies
Читать книгу Excel VBA Programming For Dummies - Dick Kusleika - Страница 1
Оглавление
Предыдущая
Следующая
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
...
84
Оглавление
Купить и скачать книгу
Вернуться на страницу книги Excel VBA Programming For Dummies
Оглавление
Страница 1
Страница 2
Excel® VBA Programming For Dummies® To view this book's Cheat Sheet, simply go to
www.dummies.com
and search for “Excel VBA Programming For Dummies Cheat Sheet” in the Search box. Table of Contents
List of Tables
List of Illustrations
Guide
Pages
Страница 8
Страница 9
Страница 10
Getting to Know VBA
Understanding VBA Basics
A FEW WORDS ABOUT TERMINOLOGY
Knowing What VBA Can Do
Inserting a bunch of text
Automating a task you perform frequently
Automating repetitive operations
Creating a custom command
Creating a custom button
Developing new worksheet functions
Creating custom add-ins for Excel
Getting the Most from VBA
Knowing what VBA does best
Recognizing the disadvantages of using VBA
Understanding VBA Concepts
Ensuring Excel Compatibility
Страница 27
Building Simple Macros
Displaying the Developer Tab
Creating a Macro
Preparing the Environment
Recording a Macro
Running the Macro
Viewing a Macro in the Visual Basic Editor
HEY, I DIDN’T RECORD THAT!
Modifying the Macro
Saving Workbooks That Contain Macros
Understanding Macro Security
Страница 39
Страница 40
Working in the Visual Basic Editor
Getting to Know the Visual Basic Editor
Activating the VBE
Exploring VBE components
Menu bar
Toolbar
Project Explorer
Code pane
Immediate window
GETTING HELP IN THE VBE
Working with the Project Explorer
Adding a new VBA module
Working with a Code Pane
Minimizing and maximizing windows
Looking at the parts of a module
Getting VBA code into a module
Entering code directly
PAUSE FOR A TERMINOLOGY BREAK
COMPILE ERROR?
Using the macro recorder
Copying VBA code
Customizing the VBE
Using the Editor tab
Using the Editor Format tab
Using the General tab
Using the Docking tab
Страница 67
Introducing the Excel Object Model
Working with the Excel Object Model
Understanding the object hierarchy
Referring to objects
Using Collection objects
Considering generic collection objects
Simplifying object references
Diving into Object Properties and Methods
A FAST-FOOD TAKE ON OBJECTS, PROPERTIES, AND METHODS
Setting object properties
Taking action with object methods
Triggering actions with object events
Finding Out More from VBA Resources
Using VBA’s Help system
Using the Object Browser
Automatically listing properties and methods
{buyButton}
Подняться наверх
