Tasuta saatmine! | Klienditugi: 7440010 (E-R 10-18)

Abi | Registreeri | Logi sisse

E-raamat: Excel VBA in easy steps, 3rd edition

3.94/5 (19 hinnangut Goodreads-ist)

Mike McGrath

Formaat: 192 pages
Sari: In Easy Steps
Ilmumisaeg: 17-Apr-2019
Kirjastus: In Easy Steps Limited
ISBN-13: 9781840788716

Teised raamatud teemal:

Formaat - EPUB+DRM
Hind: 15,90 €*
* hind on lõplik, st. muud allahindlused enam ei rakendu
Lisa ostukorvi
Lisa soovinimekirja
See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.

Formaat: 192 pages
Sari: In Easy Steps
Ilmumisaeg: 17-Apr-2019
Kirjastus: In Easy Steps Limited
ISBN-13: 9781840788716

Teised raamatud teemal:

DRM piirangud

Kopeerimine (copy/paste):

ei ole lubatud
Printimine:

ei ole lubatud
Kasutamine:

Digitaalõiguste kaitse (DRM)
Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

Vajalik tarkvara
Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

Seda e-raamatut ei saa lugeda Amazon Kindle's.

This book will help the reader gain a sound understanding of Visual Basic for Applications and be able to write their own VBA programs that can be executed in the Microsoft Excel Office application. No previous knowledge of any programming language is needed, so it's ideal for the newcomer to computer programming.

Excel VBA in easy steps neatly demonstrates VBA (Visual Basic for Applications) Macro programming in a clear and concise manner, so you can get more from the popular Microsoft Excel spreadsheet application. Areas covered include:

Recording and editing Macros

Creating your own Macro programs

Coding with the VBA language

Responding to Worksheet events

Programming Excel procedures

Making ‘DataForms’ for data editing

Producing ‘UserForms’ for data entry

Displaying dynamic Charts

Sharing your Excel apps to impress your colleagues!

Whether you’re upgrading to Excel 2019, exploring Excel in the Office 365 suite, or new to the Macro programming concept, use this guide to learn the key features constructively and get more out of Microsoft Excel – in easy steps!

1 Getting started

(16)

Introducing Excel VBA

(2)

Recording a macro

(2)

Viewing macro code

(2)

Testing a macro

(1)

Editing macro code

(1)

Referencing relatives

(2)

Saving macros

(2)

Trusting macros

(2)

Summary

(1)

2 Writing macros

(16)

Exploring the Editor

(2)

Creating a macro

(2)

Adding toolbar buttons

(2)

Adding Form Controls

(2)

Recognizing hierarchy

(2)

Identifying a range

(2)

Addressing cells

(2)

Summary

(1)

3 Storing values

(16)

Creating variables

(2)

Defining data types

(2)

Managing strings

(2)

Producing arrays

(2)

Describing dimensions

(2)

Representing objects

(2)

Declaring constants

(2)

Summary

(1)

4 Performing operations

(12)

Doing arithmetic

(2)

Making comparisons

(2)

Assessing logic

(2)

Joining strings

(2)

Understanding precedence

(2)

Summary

(1)

5 Making statements

(18)

Choosing a branch

(2)

Branching alternatives

(2)

Selecting branches

(2)

Performing loops

(2)

Looping while true

(2)

Breaking from loops

(2)

Iterating for each

(2)

Including with

(2)

Summary

(1)

6 Executing procedures

(16)

Calling subroutines

(2)

Modifying scope

(2)

Passing arguments

(2)

Adding modules

(2)

Fixing values

(2)

Debugging code

(2)

Handling errors

(2)

Summary

100

(1)

7 Employing functions

101

(18)

Defining a function

102

(2)

Calling a function

104

(2)

Scoping a function

106

(2)

Passing array arguments

108

(2)

Stating options

110

(2)

Returning errors

112

(2)

Debugging functions

114

(2)

Describing functions

116

(2)

Summary

118

(1)

8 Recognizing events

119

(18)

Creating event-handlers

120

(2)

Opening workbook events

122

(2)

Changing workbook events

124

(2)

Closing workbook events

126

(2)

Spotting worksheet changes

128

(2)

Catching worksheet clicks

130

(2)

Listening for keystrokes

132

(2)

Observing the time

134

(2)

Summary

136

(1)

9 Opening dialogs

137

(14)

Acquiring input

138

(2)

Showing messages

140

(2)

Importing files

142

(2)

Saving files

144

(2)

Producing data forms

146

(2)

Executing Ribbon commands

148

(2)

Summary

150

(1)

10 Getting UserForm dialogs

151

(18)

Inserting a UserForm

152

(2)

Adding controls

154

(2)

Comparing control types

156

(2)

Adjusting properties

158

(2)

Naming controls

160

(2)

Displaying forms

162

(2)

Handling form events

164

(2)

Managing lists

166

(2)

Summary

168

(1)

11 Developing apps

169

(18)

Ignoring modes

170

(2)

Indicating progress

172

(2)

Controlling MultiPages

174

(2)

Tabbing data pages

176

(2)

Showing chart info

178

(2)

Creating Add-ins

180

(2)

Installing Add-ins

182

(2)

Adding Ribbon buttons

184

(2)

Summary

186

(1)

Index

187

Mike McGrath now lives in South-east Europe, on the sun-kissed shores of the Aegean Sea. Mike gained his extensive knowledge of computer languages while working as a developer contracting to companies around the world. His interests include coins of ancient Greece, dining-out with friends, and the ongoing evolution of the world wide web.

Lisainfo e-raamatute kohta