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


Discussion
  • 0 Comment
Oops! There is no comments right now.
Oops! Please login or register to add comments

mctc dubai

United Arab Emirates / Dubai / Dubai

AED1.00
  • Avoid scams by acting locally or paying with PayPal
  • Never pay with Western Union, Moneygram or other anonymous payment services
  • Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
  • This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection"