Visual basic for applications vba
Download
1 / 11

Visual Basic for Applications (VBA) - PowerPoint PPT Presentation


  • 79 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