menu

Visual Basic For Excel : Supports Excel 2010, 2013, And 2016
by Jeff Hutchinson




Overview -
Excel Visual Basic is a programming tool used to enhance the capability of Excel and requires advanced skills to use it effectively.Visual Basic will help to automate repeating operations and redundant tasks. Once you understand how to use Excel VBA, you'll be able to apply your VBA programming knowledge to other MS Office products, including Microsoft Word and Access.
Obtain Your PDF Copy and Video Course
This workbook includes an Online Recorded Video course and PDF Download. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt.

This Workbook supports Excel 2010, 2013, and 2016 because the VBA commands are very similar. However, some commands function differently between Excel versions, and many of these will be noted in the courseware. Also, you will be able to create VB code and run routines that are not possible using standard Excel commands.

This Workbook will employ the Visual Basic Application (VBA) programming language that is built into Excel. Students will begin by starting the command Recorder, performing a series of commands or operations in Excel, stopping the recorder, and then running the recording to see if it operates. These Macros are stored in the Visual Basic Editor and can be edited to troubleshoot problems. The Visual Basic programming commands are included in the Macro recording, but there are hundreds of other coding commands that can accomplish fantastic results, as well. Code can also be written to open display message boxes to status the end of a routine; Input Boxes can allow you to prompt for information needed, and there are Worksheet and Workbook commands to create and manipulate information automatically. Visual Basic is designed to go beyond the capabilities of Excel and can replace a long process, completing a task in minutes.

The following are the major topics to be covered:
  • Excel Macros - These can be recorded, stored, and run to automate many tasks.
  • Visual Basic Editor - Here, we will cover the editing, debugging, and storage locations of VB code.
  • Cell Manipulation - Excel is made up of many cells and here we will review cell manipulation capabilities. This is an extremely important chapter because these commands are very often used.
  • Formatting Techniques - Although Recording Macros would be the best approach to Format Cells, there are many additional Visual Basic formatting tools to understand.
  • Variables - These are great methods to help remember specific items for use at a later time.
  • "If" Logic - This will be covered to help automate decisions and provide the logic necessary to make adjustments.
  • Message and Input Boxes - These tools are methods to provide Input Boxes in a popup window with results being stored in a cell.
  • Loops - This will provide the logic to repeat steps in multiple cells.
  • Worksheet and Workbook - This will allow access to data from multiple worksheets. The use of these functions will automate the overall efficiency of a project.
  • Functions - There are many more advanced programming techniques that can create more efficient code.

What's in the Workbook? Click on the left side of the screen: Look Inside
Enter one of the following keywords: VB, Programming, VBA, Variables, Forms, etc.

  Read Full Product Description
 
local_shippingFor Delivery
In Stock.
This item is Non-Returnable.
FREE Shipping for Club Members help
 
storeBuy Online Pickup At Store
search store by zipcode

 
 
New & Used Marketplace 2 copies from $9.88
 
 
 

More About Visual Basic For Excel by Jeff Hutchinson

 
 
 

Overview

Excel Visual Basic is a programming tool used to enhance the capability of Excel and requires advanced skills to use it effectively.Visual Basic will help to automate repeating operations and redundant tasks. Once you understand how to use Excel VBA, you'll be able to apply your VBA programming knowledge to other MS Office products, including Microsoft Word and Access.
Obtain Your PDF Copy and Video Course
This workbook includes an Online Recorded Video course and PDF Download. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt.

This Workbook supports Excel 2010, 2013, and 2016 because the VBA commands are very similar. However, some commands function differently between Excel versions, and many of these will be noted in the courseware. Also, you will be able to create VB code and run routines that are not possible using standard Excel commands.

This Workbook will employ the Visual Basic Application (VBA) programming language that is built into Excel. Students will begin by starting the command Recorder, performing a series of commands or operations in Excel, stopping the recorder, and then running the recording to see if it operates. These Macros are stored in the Visual Basic Editor and can be edited to troubleshoot problems. The Visual Basic programming commands are included in the Macro recording, but there are hundreds of other coding commands that can accomplish fantastic results, as well. Code can also be written to open display message boxes to status the end of a routine; Input Boxes can allow you to prompt for information needed, and there are Worksheet and Workbook commands to create and manipulate information automatically. Visual Basic is designed to go beyond the capabilities of Excel and can replace a long process, completing a task in minutes.

The following are the major topics to be covered:
  • Excel Macros - These can be recorded, stored, and run to automate many tasks.
  • Visual Basic Editor - Here, we will cover the editing, debugging, and storage locations of VB code.
  • Cell Manipulation - Excel is made up of many cells and here we will review cell manipulation capabilities. This is an extremely important chapter because these commands are very often used.
  • Formatting Techniques - Although Recording Macros would be the best approach to Format Cells, there are many additional Visual Basic formatting tools to understand.
  • Variables - These are great methods to help remember specific items for use at a later time.
  • "If" Logic - This will be covered to help automate decisions and provide the logic necessary to make adjustments.
  • Message and Input Boxes - These tools are methods to provide Input Boxes in a popup window with results being stored in a cell.
  • Loops - This will provide the logic to repeat steps in multiple cells.
  • Worksheet and Workbook - This will allow access to data from multiple worksheets. The use of these functions will automate the overall efficiency of a project.
  • Functions - There are many more advanced programming techniques that can create more efficient code.

What's in the Workbook? Click on the left side of the screen: Look Inside
Enter one of the following keywords: VB, Programming, VBA, Variables, Forms, etc.


This item is Non-Returnable.

 

Details

  • ISBN-13: 9781979929073
  • ISBN-10: 1979929076
  • Publisher: Createspace Independent Publishing Platform
  • Publish Date: November 2017
  • Page Count: 212
  • Dimensions: 11 x 8.5 x 0.45 inches
  • Shipping Weight: 1.11 pounds

Series: Excel 2016-5 #5

Related Categories

 

BAM Customer Reviews