Cette publication ne fait pas partie de la bibliothèque YouScribe
Elle est disponible uniquement à l'achat (la librairie de YouScribe)
Achetez pour : 26,38 € Lire un extrait

Téléchargement

Format(s) : EPUB

avec DRM

Partagez cette publication

Du même publieur

HOW TO USE THIS BOOK V
1 USING MACROS AND FORM CONTROLS 2
Introducing Excel Programming 2
Introducing Macros 4
Set Macro Security 6
Create a Digital Signature 7
Record a Macro 8
Assign a Digital Signature to a Macro 10
Run a Macro 12
Create and Launch a Keyboard Shortcut 14
Assign a Macro to the Quick Access Toolbar 16
Delete a Macro 18
Add a Form Control to a Worksheet 20
Assign Values to a Form Control 22
Add a Macro to a Form Control 24
2 USING THE VISUAL BASIC EDITOR 26
Introducing the Visual Basic Editor 26
Activate the Visual Basic Editor 28
Open Visual Basic Editor Windows 30
Set Properties for a Project 32
Set Display Options for the Code Window 34
Add a New Module 36
Remove a Module 38
Hide a Macro 40
Update a Macro 42
3 INTRODUCING VISUAL BASIC FOR APPLICATIONS 44
Create Sub Procedures 44
Create Functions 46
Comment Your Code 48
Reference Cells and Ranges 50
Understanding Variables and Data Types 52
Declare Variables 54
Work with Strings 56
Work with Numbers 58
Create a Constant 60
4 INTRODUCING THE EXCEL OBJECT MODEL 62
Discover the Excel Object Model 62
Access the Excel Object Model Reference 64
Create an Object Variable 66
Change the Properties of an Object 68
Compare Object Variables 70
Using an Object Method 72
Display a Built-in Dialog Box 74
5 UNDERSTANDING ARRAYS 76
Declare an Array 76
Declare a Multidimensional Array 78
Convert a List to an Array 80
Redimension an Array 82
Create a User-Defined Data Type 84
6 CONTROLLING PROGRAM FLOW 86
Create Comparisons 86
Make Use of Logical Operators 87
Employ Do While Loops 88
Create Do Until Loops 90
Create For Next Loops 92
Execute For Each In Loops 94
Create If Then Else Statements 96
Construct Select Case Statements 98
GoTo a Named Location 100
Call a Procedure 102
7 USING EXCEL WORKSHEET FUNCTIONS 104
Work with Excel Worksheet Functions 104
Work with a MsgBox Function 106
Using the InputBox Function 108
Retrieve the Current Date and Time 110
Perform Date and Time Calculations 112
Format a Date Expression 114
Format a Numeric Expression 116
Change the Case of a String 118
Return a Portion of a String 120
8 DEBUGGING MACROS 122
Debug a Procedure with Inserted Breakpoints 122
Using the Watches Window to Debug a Procedure 124
Step through a Procedure 126
Using the Immediate Window 128
Resume Execution When an Error Is Encountered 130
Process a Runtime Error 132
9 WORKING WITH WORKBOOKS AND FILES 134
Open a Workbook 134
Open a Text File as a Workbook 136
Open a File Requested by the User 138
Save a Workbook 140
Save a Workbook in a Format Specified by the User 142
Determine if a Workbook Is Open 144
Close a Workbook 146
Create a New Workbook 148
Delete a File 150
10 WORKING WITH WORKSHEETS 152
Add a Sheet 152
Delete a Sheet 154
Un pour Un
Permettre à tous d'accéder à la lecture
Pour chaque accès à la bibliothèque, YouScribe donne un accès à une personne dans le besoin