The Resource Excel VBA in easy steps, Mike McGrath
Excel VBA in easy steps, Mike McGrath
Resource Information
The item Excel VBA in easy steps, Mike McGrath represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Randwick City Library.This item is available to borrow from 1 library branch.
Resource Information
The item Excel VBA in easy steps, Mike McGrath represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Randwick City Library.
This item is available to borrow from 1 library branch.
- Summary
- Excel VBA in easy steps begins by explaining how to record and edit macro procedures to manipulate Excel worksheet entries, then describes how to create your own macro programs in the Visual Basic Editor (VBE) that is included with the Excel application. This book then demonstrates how to program Excel procedures, provide Excel user forms, and create Excel apps. Each chapter builds your knowledge of Visual Basic for Applications. Excel VBA in easy steps contains separate chapters on the major features of the VBA language. There are complete example programs that demonstrate each aspect of Visual Basic for Applications together with screenshots that illustrate the output when that program has been executed. The sample code provided all has coloured syntax-highlighting for clearer understanding. By the end of this book you will have gained a sound understanding of Visual Basic for Applications and be able to write your own VBA programs that can be executed in the Microsoft Excel Office application. You need have no previous knowledge of any programming language, so it's ideal for the newcomer to computer programming
- Language
- eng
- Edition
- Second edition.
- Extent
- 192 pages
- Note
- Includes index
- Contents
-
- Machine generated contents note: Introducing Excel VBA -- Recording a macro -- Viewing macro code -- Testing a macro -- Editing macro code -- Referencing relatives -- Saving macros -- Trusting macros -- Summary -- Exploring the Editor -- Creating a macro -- Adding toolbar buttons -- Adding form controls -- Recognizing hierarchy -- Identifying a Range -- Addressing Cells -- Summary -- Creating variables -- Defining data types -- Managing strings -- Producing arrays -- Describing dimensions -- Representing objects -- Declaring constants -- Summary -- Doing arithmetic -- Making comparisons -- Assessing logic -- Joining strings -- Understanding precedence -- Summary -- Choosing a branch -- Branching alternatives -- Selecting branches -- Performing loops -- Looping while true -- Breaking from loops -- Iterating for each -- Including with -- Summary -- Calling subroutines -- Modifying scope -- Passing arguments -- Adding modules -- Fixing values -- Debugging code -- Handling errors --
- Contents note continued: Summary -- Defining a function -- Calling a function -- Scoping a function -- Passing array arguments -- Stating options -- Returning errors -- Debugging functions -- Describing functions -- Summary -- Creating event-handlers -- Opening workbook events -- Changing workbook events -- Closing workbook events -- Spotting worksheet changes -- Catching worksheet clicks -- Listening for keystrokes -- Observing the time -- Summary -- Acquiring input -- Showing messages -- Importing files -- Saving files -- Producing data forms -- Executing Ribbon commands -- Summary -- Inserting a UserForm -- Adding controls -- Comparing control types -- Adjusting properties -- Naming controls -- Displaying forms -- Handling form events -- Managing lists -- Summary -- Ignoring modes -- Indicating progress -- Controlling MultiPages -- Tabbing data pages -- Showing chart info -- Creating Add-ins -- Installing Add-ins -- Adding Ribbon buttons -- Summary
- Isbn
- 9781840787375
- Label
- Excel VBA in easy steps
- Title
- Excel VBA in easy steps
- Statement of responsibility
- Mike McGrath
- Title variation
-
- Excel VBA in easy steps
- Excel VBA
- Title variation remainder
- get Excel to do more for you!
- Language
- eng
- Summary
- Excel VBA in easy steps begins by explaining how to record and edit macro procedures to manipulate Excel worksheet entries, then describes how to create your own macro programs in the Visual Basic Editor (VBE) that is included with the Excel application. This book then demonstrates how to program Excel procedures, provide Excel user forms, and create Excel apps. Each chapter builds your knowledge of Visual Basic for Applications. Excel VBA in easy steps contains separate chapters on the major features of the VBA language. There are complete example programs that demonstrate each aspect of Visual Basic for Applications together with screenshots that illustrate the output when that program has been executed. The sample code provided all has coloured syntax-highlighting for clearer understanding. By the end of this book you will have gained a sound understanding of Visual Basic for Applications and be able to write your own VBA programs that can be executed in the Microsoft Excel Office application. You need have no previous knowledge of any programming language, so it's ideal for the newcomer to computer programming
- Cataloging source
- BTCTA
- http://library.link/vocab/creatorDate
- 1956-
- http://library.link/vocab/creatorName
- McGrath, Mike
- Dewey number
- 005.5
- Illustrations
- illustrations
- Index
- index present
- Literary form
- non fiction
- Series statement
- In easy steps
- http://library.link/vocab/subjectName
-
- Electronic spreadsheets
- Visual Basic (Computer program language)
- Label
- Excel VBA in easy steps, Mike McGrath
- Note
- Includes index
- Carrier category
- volume
- Carrier category code
-
- nc
- Carrier MARC source
- rdacarrier
- Content category
-
- text
- still image
- Content type code
-
- txt
- sti
- Content type MARC source
-
- rdacontent
- rdacontent
- Contents
-
- Machine generated contents note: Introducing Excel VBA -- Recording a macro -- Viewing macro code -- Testing a macro -- Editing macro code -- Referencing relatives -- Saving macros -- Trusting macros -- Summary -- Exploring the Editor -- Creating a macro -- Adding toolbar buttons -- Adding form controls -- Recognizing hierarchy -- Identifying a Range -- Addressing Cells -- Summary -- Creating variables -- Defining data types -- Managing strings -- Producing arrays -- Describing dimensions -- Representing objects -- Declaring constants -- Summary -- Doing arithmetic -- Making comparisons -- Assessing logic -- Joining strings -- Understanding precedence -- Summary -- Choosing a branch -- Branching alternatives -- Selecting branches -- Performing loops -- Looping while true -- Breaking from loops -- Iterating for each -- Including with -- Summary -- Calling subroutines -- Modifying scope -- Passing arguments -- Adding modules -- Fixing values -- Debugging code -- Handling errors --
- Contents note continued: Summary -- Defining a function -- Calling a function -- Scoping a function -- Passing array arguments -- Stating options -- Returning errors -- Debugging functions -- Describing functions -- Summary -- Creating event-handlers -- Opening workbook events -- Changing workbook events -- Closing workbook events -- Spotting worksheet changes -- Catching worksheet clicks -- Listening for keystrokes -- Observing the time -- Summary -- Acquiring input -- Showing messages -- Importing files -- Saving files -- Producing data forms -- Executing Ribbon commands -- Summary -- Inserting a UserForm -- Adding controls -- Comparing control types -- Adjusting properties -- Naming controls -- Displaying forms -- Handling form events -- Managing lists -- Summary -- Ignoring modes -- Indicating progress -- Controlling MultiPages -- Tabbing data pages -- Showing chart info -- Creating Add-ins -- Installing Add-ins -- Adding Ribbon buttons -- Summary
- Control code
- 000059660735
- Dimensions
- 23 cm.
- Edition
- Second edition.
- Extent
- 192 pages
- Isbn
- 9781840787375
- Media category
- unmediated
- Media MARC source
- rdamedia
- Media type code
-
- n
- Other physical details
- colour illustrations
- System control number
- (OCoLC)951948038
- Label
- Excel VBA in easy steps, Mike McGrath
- Note
- Includes index
- Carrier category
- volume
- Carrier category code
-
- nc
- Carrier MARC source
- rdacarrier
- Content category
-
- text
- still image
- Content type code
-
- txt
- sti
- Content type MARC source
-
- rdacontent
- rdacontent
- Contents
-
- Machine generated contents note: Introducing Excel VBA -- Recording a macro -- Viewing macro code -- Testing a macro -- Editing macro code -- Referencing relatives -- Saving macros -- Trusting macros -- Summary -- Exploring the Editor -- Creating a macro -- Adding toolbar buttons -- Adding form controls -- Recognizing hierarchy -- Identifying a Range -- Addressing Cells -- Summary -- Creating variables -- Defining data types -- Managing strings -- Producing arrays -- Describing dimensions -- Representing objects -- Declaring constants -- Summary -- Doing arithmetic -- Making comparisons -- Assessing logic -- Joining strings -- Understanding precedence -- Summary -- Choosing a branch -- Branching alternatives -- Selecting branches -- Performing loops -- Looping while true -- Breaking from loops -- Iterating for each -- Including with -- Summary -- Calling subroutines -- Modifying scope -- Passing arguments -- Adding modules -- Fixing values -- Debugging code -- Handling errors --
- Contents note continued: Summary -- Defining a function -- Calling a function -- Scoping a function -- Passing array arguments -- Stating options -- Returning errors -- Debugging functions -- Describing functions -- Summary -- Creating event-handlers -- Opening workbook events -- Changing workbook events -- Closing workbook events -- Spotting worksheet changes -- Catching worksheet clicks -- Listening for keystrokes -- Observing the time -- Summary -- Acquiring input -- Showing messages -- Importing files -- Saving files -- Producing data forms -- Executing Ribbon commands -- Summary -- Inserting a UserForm -- Adding controls -- Comparing control types -- Adjusting properties -- Naming controls -- Displaying forms -- Handling form events -- Managing lists -- Summary -- Ignoring modes -- Indicating progress -- Controlling MultiPages -- Tabbing data pages -- Showing chart info -- Creating Add-ins -- Installing Add-ins -- Adding Ribbon buttons -- Summary
- Control code
- 000059660735
- Dimensions
- 23 cm.
- Edition
- Second edition.
- Extent
- 192 pages
- Isbn
- 9781840787375
- Media category
- unmediated
- Media MARC source
- rdamedia
- Media type code
-
- n
- Other physical details
- colour illustrations
- System control number
- (OCoLC)951948038
Embed
Settings
Select options that apply then copy and paste the RDF/HTML data fragment to include in your application
Embed this data in a secure (HTTPS) page:
Layout options:
Include data citation:
<div class="citation" vocab="http://schema.org/"><i class="fa fa-external-link-square fa-fw"></i> Data from <span resource="http://link.randwick.nsw.gov.au/portal/Excel-VBA-in-easy-steps-Mike-McGrath/eKFD3e-1iiU/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.randwick.nsw.gov.au/portal/Excel-VBA-in-easy-steps-Mike-McGrath/eKFD3e-1iiU/">Excel VBA in easy steps, Mike McGrath</a></span> - <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.randwick.nsw.gov.au/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.randwick.nsw.gov.au/">Randwick City Library</a></span></span></span></span></div>
Note: Adjust the width and height settings defined in the RDF/HTML code fragment to best match your requirements
Preview
Cite Data - Experimental
Data Citation of the Item Excel VBA in easy steps, Mike McGrath
Copy and paste the following RDF/HTML data fragment to cite this resource
<div class="citation" vocab="http://schema.org/"><i class="fa fa-external-link-square fa-fw"></i> Data from <span resource="http://link.randwick.nsw.gov.au/portal/Excel-VBA-in-easy-steps-Mike-McGrath/eKFD3e-1iiU/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.randwick.nsw.gov.au/portal/Excel-VBA-in-easy-steps-Mike-McGrath/eKFD3e-1iiU/">Excel VBA in easy steps, Mike McGrath</a></span> - <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.randwick.nsw.gov.au/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.randwick.nsw.gov.au/">Randwick City Library</a></span></span></span></span></div>
