table layout
Search

Guest

Microsoft Excel VBA course in Dubai

ServicesAdd to Favourites
Price is negotiable
Contact 0552239282
www.mctcdubai.com
Added 2019-02-06 17:44:11

Description

MCTC Dubai offers professional training for all the computer courses in Dubai

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

During our 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 VBA Language

  • 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

Modifying the 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-Oriented Programming

  • 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

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

www.mctcdubai.com

Location

Deira, Dubai, UAE United Arab Emirates
M-06, Al Ahrar Building, Salah Al Din Street, Deira, Dubai

Advert details

Advert ID: 356663
Displayed: 27
Expires: 2019-04-07 17:44:00

Comments

Advanced Search

Total ads: 35234
Active ads: 10625
Added today: 68
Added current month: 4088
Categories: 368