Login for faster access to the best deals. Click here if you don't have an account.

Microsoft Excel VBA course in Dubai Individual

2 months ago Learning Dubai   47 views

1 د.إ

  • img
Location: Dubai
Price: 1 د.إ Negotiable

Do you want toautomate your routine tasks and customize Excel UI? Enroll with MCTC Dubai andlearn on your schedule, with affordable fees, from well qualified and highlyexperienced trainers!.VBA, which stands for Visual Basic forApplications, is a programming language developed by Microsoft. Excel,along with the other members of Microsoft Office 2003, includes the VBAlanguage (at no extra charge). In a nutshell, VBA is the tool that people useto develop programs that control Excel.

Duringour training, we will cover:

Features

  • Automating repetitive operations
  • Automating a task you perform frequently
  • Inserting a text string
  • Automating repetitive operations
  • Creating a custom command
  • Creating a custom toolbar button
  • Creating a custom menu command
  • Creating a simplified front end
  • Developing new worksheet functions
  • Creating complete, macro-driven applications
  • Creating custom add-ins for excel

The VBALanguage

  • Simple Input & Output
  • Variables & Data Types
  • VBA & Worksheet Functions
  • Object Type Variables
  • Branching: IF…THEN
  • Branching: SELECT…CASE
  • Looping: DO…LOOP
  • Looping: FOR…NEXT
  • Looping: FOR…EACH
  • User-Defined Functions
  • Variable Scope
  • Error Handling

Launching Macros: Events & Shortcuts

  • Macro Launching Shortcuts
  • Modifying the Ribbon
  • Workbook & Worksheet Events
  • Application Events
  • Project 2 – Event Handling
  • Launching Macros: Events & Shortcuts

Modifyingthe User Interface

  • Enhanced Message Box
  • ActiveX & The Worksheet (No Code)
  • ActiveX & The Worksheet (With Code)
  • Basic User Forms
  • Project 3 – User Forms & ActiveX
  • Modifying the User Interface

Object-OrientedProgramming

  • Classes and Objects
  • Creating classes
  • Creating and Destroying Objects
  • Create methods
  • Create property
  • Validation data using property
  • The default properties and methods
  • Error handling in the class

Forfurther queries, feel free to contact us on 0552239282/ 042970083/ 042556969

www.mctcdubai.com