Magnificent Marvel Supersale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | March 26, 2015

    Kyle Boelte: IMG Selfies, Memoir, and the World Beyond the Self



    When I was a teenager in Colorado during the late '90s, I liked to climb 14ers — 14,000-foot mountains. I'd often hike with friends, and at... Continue »

    spacer
Qualifying orders ship free.
$4.25
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Local Warehouse COMP- WIN APPS A- Z

Excel Prog Your Visual Blueprint for 2ND Edition

by

Excel Prog Your Visual Blueprint for 2ND Edition Cover

 

Synopses & Reviews

Publisher Comments:

Excel® Programming  2nd Edition

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 120 key Excel programming techniques, including:

  • Creating and launching keyboard shortcuts
  • Setting macro security
  • Assigning a digital signature
  • Developing a function with VBA
  • Displaying a built-in dialog box
  • Converting a list into an array
  • Using the msgbox function
  • Processing a runtime error
  • Saving a workbook in a specified format
  • Finding the intersection of two ranges

Synopsis:

Each step in this visual reference is displayed with callouts so you can see exactly where the action takes place on the screen. It covers over 100 tasks, including complete coverage of macros — with info about VBA basic techniques, variables and arrays, control statements, interfacing with other macros, debugging, add-ins, and automation.  The CD-ROM includes tons of usable code and sample macros and a fully searchable version of the book.

Synopsis:

Excel® Programming  2nd Edition

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 120 key Excel programming techniques, including: Creating and launching keyboard shortcuts Setting macro security Assigning a digital signature Developing a function with VBA Displaying a built-in dialog box Converting a list into an array Using the msgbox function Processing a runtime error Saving a workbook in a specified format Finding the intersection of two ranges

Synopsis:

* Covers more than 100 tasks, with information about VBA basic techniques, variables and arrays, control statements, interfacing with other macros, debugging, add-ins, and automation

* Most tasks are explained in two-page spreads, newly redesigned to make learning even easier

* Displays every step with callouts so the reader can see exactly where the action takes place on the screen

* Highlights the enhanced features of the new Excel version, including support for XML file formats, saving files as Web pages, using graphics in headers and footers, and enhancements to PivotTables

* Includes a CD-ROM with all the code samples, sample macros, and a searchable version of the book

Synopsis:

Excel(r) Programming 2nd Edition

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 120 key Excel programming techniques, including:

* Creating and launching keyboard shortcuts

* Setting macro security

* Assigning a digital signature

* Developing a function with VBA

* Displaying a built-in dialog box

* Converting a list into an array

* Using the msgbox function

* Processing a runtime error

* Saving a workbook in a specified format

* Finding the intersection of two ranges

About the Author

Jinjer Simon has been actively involved in the computer industry for the past 18 years. Her involvement includes programming, providing software technical support, training end-users, developing written and online user documentation, creating software tutorials, and developing Web sites. She is the author of several computer books, including Excel Programming: Your visual blueprint for creating interactive spreadsheets, and Windows CE 2 For Dummies.

Table of Contents

HOW TO USE THIS BOOK.

GETTING STARED WITH EXCEL MACROS.

Introduction to Macros.

Record a Macro.

Run a Macro.

Create and Launch a Keyboard Shortcut.

Delete a Macro from a Workbook.

Delete from the Personal Macro Workbook.

Assign a Macro to a Toolbar Button.

Assign a Macro to a Menu.

Set Macro Security.

USING THE VISUAL BASIC EDITOR.

An Introduction to the Visual Basic Editor.

Activate the Visual Basic Editor.

Arrange the Visual Basic Editor Windows.

Set Properties for a Project.

Set Display Options for the Code Window.

Add a New Module.

Remove a Module.

Rename a Macro.4

Create a Startup Macro.

Hide a Macro.

Assign a Digital Signature to a Macro.

Update a Recorded Macro.

VBA PROGRAMMING BASICS.

An Introduction to VBA.

Create a Subroutine.

Create a Function.

Declare a Variable.

Perform Mathematical Calculations.

Create a Constant.

Comment Your Code.

Join Two Strings.

WORKING WITH THE EXCEL OBJECT MODEL.

An Introduction to the Excel Object Model.

Using the Object Browser.

Create an Object Variable.

Change the Properties of an Object.

Compare Object Variables.

Using an Object Method.

Display a Built-in Dialog Box.

USING VARIABLES AND ARRAYS.

Assign Values to Variables.

Using Global Variables.

Declare an Array.

Declare a Multidimensional Array.

Convert a List into an Array.

Redimension an Array.

Create a User-Defined Data Type.

ADDING CONTROL STATEMENTS.

Execute a Task While a Condition is True.2

Perform Multiple Tasks Until a Condition is Met.

Execute Tasks a Specific Number of Times.

Using the For Each Next Loop.

Conditionally Execute a Group of Statements.

Execute a Statement Based upon the Value.

Jump to a Specific Location in a Macro.

Conditionally Call a Subroutine.

USING BUILT-IN FUNCTIONS AND STATEMENTS.

Using Excel Worksheet Functions.

Using the MsgBox Function.

Using the InputBox Function.

Retrieve Current Date and Time.

Determine the Amount of Time between Dates.

Format a Date Expression.

Format a Numeric Expression.

Remove Extra Spacing from a String.

Return a Portion of a String.

Compare Two Strings.

DEBUGGING MACROS.

Debugging Basics.

Debug a Procedure with Inserted Break Points.

Using Watch Expressions to Debug a Procedure.

Step through a Procedure.

Resume Execution if an Error is Encountered.

Process a Runtime Error.

WORKING WITH OTHER WORKBOOKS AND FILES.

Open a Workbook.

Open a Text File as a Workbook.

Open a File Requested by the User.

Save a Workbook.6

Save Workbook in Format Specified by User.

Determine if a Workbook is Open.0

Close a Workbook.

Create a New Workbook.

Delete a File.

Find a File.

WORKING WITH WORKSHEETS.

Add a Sheet.

Delete a Sheet.

Move a Sheet.

Copy and Paste a Sheet.

Hide a Sheet.

Change the Name of a Sheet.

Save a Sheet to Another File.

Protect a Worksheet.

Protect a Chart.

Print a Sheet.

Sort Worksheets by Name.

DEFINING RANGES.

Using the Range Property.

Using the Cells Property.

Combine Multiple Ranges.

Using the Offset Property.

Delete a Range of Cells.

Hide a Range of Cells.

Specify the Name of a Range.

Resize a Range.

Insert a Range.

Set the Width of Columns in a Range.

Set the Height of Rows in a Range.

Convert a Column of Text into Multiple Columns.

Find the Intersection of Two Ranges.

WORKING WITH CELLS.

Cut and Paste Ranges of Cells.

Copy and Paste Ranges of Cells.0

Custom Paste Values in Cells.

Add Comments to a Cell.

Automatically Fill a Range of Cells.

Copy a Range to Multiple Sheets.

Place Borders around a Range of Cells.

Find Specific Cell Values.

Find and Replace Values in Cells.

CUSTOMIZING DIALOG BOXES, MENUS, AND TOOLBARS.

UserForm Basics.

Working with CommandBars.

Create a Custom Dialog Box.

Call a Custom Dialog Box from a Procedure.

Capture Input from a Custom Dialog Box.

Validate Input from a Dialog Box.

Create Custom UserForm Controls.

Create a UserForm Template.

Create a Custom Toolbar.

Add Controls to a Toolbar.

Create a Custom Menu.

Add Items to a Menu.

Create a Shortcut Menu.

Delete Custom Toolbars and Shortcut Menus.

WORKING WITH CHARTS.

Chart Basics.

Create a Chart Sheet.

Embed a Chart within a Worksheet.

Apply Chart Wizard Settings to a Chart.

Add a New Data Series to a Chart.

Format Chart Text.

Create Charts with Multiple Chart Types.

Determine Variations in a Series of Data.

Add a Data Table to the Chart.

Customize the Chart Axis.

AUTOMATING PROCEDURES WITH EXCEL EVENTS.

Understanding Excel Events.

Run a Procedure as a Workbook Opens.

Run a Procedure before Closing a Workbook.

Run a Procedure before Saving a Workbook.

Run a Procedure When Excel Creates a Workbook.

Monitor a Range of Cells for Changes.

Execute a Procedure at a Specific Time.

Execute a Procedure When You Press Keys.

Run a Procedure When Right-Clicking a Chart.

APPENDIX A: VBA QUICK REFERENCE.

VBA and Excel Object Model Quick Reference.

APPENDIX B: ABOUT THE CD-ROM.

What Is on the CD-ROM.

Using the E-Version of This Book.

Wiley Publishing, Inc. End-User License Agreement.

Product Details

ISBN:
9780764597817
Subtitle:
Your visual blueprint for creating interactive spreadsheets
Author:
Simon, Jinjer
Publisher:
Visual
Subject:
Spreadsheets - General
Subject:
Spreadsheets - Excel
Subject:
Microsoft Excel
Copyright:
Edition Number:
2
Edition Description:
CD
Series:
Visual Blueprint
Series Volume:
19
Publication Date:
20050902
Binding:
Electronic book text in proprietary or open standard format
Language:
English
Illustrations:
Y
Pages:
352
Dimensions:
8.96x8.00x.93 in. 1.71 lbs.

Related Subjects

Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Excel Prog Your Visual Blueprint for 2ND Edition Used Trade Paper
0 stars - 0 reviews
$4.25 In Stock
Product details 352 pages Visual - English 9780764597817 Reviews:
"Synopsis" by , Each step in this visual reference is displayed with callouts so you can see exactly where the action takes place on the screen. It covers over 100 tasks, including complete coverage of macros — with info about VBA basic techniques, variables and arrays, control statements, interfacing with other macros, debugging, add-ins, and automation.  The CD-ROM includes tons of usable code and sample macros and a fully searchable version of the book.
"Synopsis" by , Excel® Programming  2nd Edition

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 120 key Excel programming techniques, including: Creating and launching keyboard shortcuts Setting macro security Assigning a digital signature Developing a function with VBA Displaying a built-in dialog box Converting a list into an array Using the msgbox function Processing a runtime error Saving a workbook in a specified format Finding the intersection of two ranges

"Synopsis" by , * Covers more than 100 tasks, with information about VBA basic techniques, variables and arrays, control statements, interfacing with other macros, debugging, add-ins, and automation

* Most tasks are explained in two-page spreads, newly redesigned to make learning even easier

* Displays every step with callouts so the reader can see exactly where the action takes place on the screen

* Highlights the enhanced features of the new Excel version, including support for XML file formats, saving files as Web pages, using graphics in headers and footers, and enhancements to PivotTables

* Includes a CD-ROM with all the code samples, sample macros, and a searchable version of the book

"Synopsis" by , Excel(r) Programming 2nd Edition

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 120 key Excel programming techniques, including:

* Creating and launching keyboard shortcuts

* Setting macro security

* Assigning a digital signature

* Developing a function with VBA

* Displaying a built-in dialog box

* Converting a list into an array

* Using the msgbox function

* Processing a runtime error

* Saving a workbook in a specified format

* Finding the intersection of two ranges

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.