visual basic for applications vba
Download
Skip this Video
Download Presentation
Visual Basic for Applications (VBA)

Loading in 2 Seconds...

play fullscreen
1 / 11

Visual Basic for Applications (VBA) - PowerPoint PPT Presentation


  • 81 Views
  • Uploaded on

Visual Basic for Applications (VBA). An object-oriented programming language Instructions for the manipulation of objects A structured way to provide instructions to Excel Excel has an Object Library that defines its set of objects (e.g. workbooks, charts, ranges of cells). Logic of Language.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Visual Basic for Applications (VBA)' - gage-bauer


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
visual basic for applications vba
Visual Basic for Applications (VBA)
  • An object-oriented programming language
    • Instructions for the manipulation of objects
    • A structured way to provide instructions to Excel
  • Excel has an Object Library that defines its set of objects (e.g. workbooks, charts, ranges of cells)
logic of language
Logic of Language
  • First part of a command identifies the object
  • Second part of command:
    • Sets a property of the object (e.g. color or font)
    • Takes an action on the object (e.g.copy or move)
    • Sets an attribute to the object (e.g. assigns a value to it using := )
example of an instruction
Example of an Instruction
  • Application.Workbooks(“Book1.xls”).Worksheets(“Sheet1”).Range(“A1”).Font.Name=“Arial”
  • Application.Workbooks(“Book1.xls”).Worksheets(“Sheet1”).Range(“A1”) is the object
  • Font.Name=“Arial” is the property being set
control of vba
Control of VBA
  • A Procedure is a set of instructions that operate on a set of objects
  • A Function is a procedure that returns a value as a result
  • A Subroutine is a procedure that can be run or used by another macro
bluecell macro
BlueCell Macro
  • Sub bluecell()
  • \'
  • \' bluecell Macro
  • \' Macro recorded 10/12/2002 by LMU LMU
  • \'
  • \'
  • With Selection.Interior
  • .ColorIndex = 8
  • .Pattern = xlSolid
  • .PatternColorIndex = xlAutomatic
  • End With
  • End Sub
running macros
Running Macros
  • Run Macro option
  • Shortcut Keys: [Ctrl][Shift] letter
  • Command Buttons
  • Custom Toolbar
running solver through a macro
Running Solver through a Macro
  • Solver dialog box must have been opened at least once in current Excel session (i.e. Solver must be currently activated in Excel)
  • SolverSolve UserFinish:=True
  • Tools Reference option in VBA must have Solver selected
debugging vba code
Debugging VBA Code
  • When VBA encounters a problem, it will highlight line in yellow.
  • Use [f8] key to step through code
  • Use the Reset icon button (square) at top of VBA to exit step-through mode and trouble- shoot code or Excel/VBA settings. Cannot retry macro until yellow highlight is gone.
ad