VBA theoritical concepts : Course presentation ( .pptx )
  • Introduction to VBA : Visual basic for applications.
  • VBA : Selectors and Properties ( Plz Download pptx presentation here )
  • Handling Variables
  • Conditions and Loops : If statements , For each , For next , select case , etc
  • Functions and procedures !
  • VBA events and Objects : Application.Object.Property !
  • Graphical programs : Forms , Buttons , lists , dialog boxes , etc.
  • Handling strings : Lcase , Ubound , strreverse , Trim , etc.
  • Usefull Built-in functions : Time , Random integers , etc.
Practical excercices .
  • VBA Crud operations : ( Add , Delete , Modify rows ) - Build Your first GUI app
  • VBA activecell.offset ( Row , Column )
  • MsgBOx , InpuBox , Worksheets( ) . activate
  • Create a simple calculatrice : How to use of select case ?
  • VBA : Example of a recursive procedure
  • VBA InputBox type:= options !
  • VBA : Compute integer part - Use of If statements .
  • Workbooks and Worksheets : Create - Open - Delete -Current path - rename - count
  • How to save macros ?
Databases & VBA ODBC
  • Relational databases
  • using phpmyadmin (graphical mode)
  • ODBC Tutorial