Visual Basic Editor (VBE) In Excel

Duration: 35 days

Online  Fee: 10,000

Classroom Fee: 3000

 

Visual Basic Editor (VBE) In Excel

  • The Project Window in the Visual Basic Editor of Excel
  • The Properties Window In Visual Basic Editor of Excel
  • The Code Window In The Visual Basic Editor of Excel
  • Developing Macros In The VBE
  • Testing macros In The EBE
  • Excel macro Recorder
  • Macros Help and Assistance
  • VBA Events
  • VBA Security and Protection
  • VBA Coding Tips
  • Dealing with Errors
  • Working with the Application
  • Working with the Workbooks
  • Working with the Worksheets
  • Moving Around the Worksheets
  • Working with Message and Input Boxes
  • Excel VBA Vocabulary to Filter and Sort Data
  • Working with Variables
  • Working with Statements
  • Working with Functions
  • Working with External Data and SQL
  • Working with Windows and Other Microsoft Programs from Excel
  • Forms (User forms) In VBA for Excel
  • User forms Properties and VBA Code
  • Properties and VBA Code for Command Buttons
  • Properties and VBA Code for Labels
  • Properties and VBA Code for Text Boxes
  • Properties and VBA Code for Combo Boxes
  • Properties and VBA Code for List Boxes
  • Properties and VBA Code for Check Boxes, Option Buttons and Frames
  • Properties and VBA Code for Spin Buttons
  • Excel Image Controls