This course is ideally aimed at experienced Excel users who wish to go beyond using formulas on their spreadsheets.
Recording visual basic “Macros” | The visual basic environment | Assigning code to buttons, menu’s and toolbars | The “Personal Macro Workbook”
Modules and procedures (private and public) | Properties and methods | Variables | Dim | If…Then…Else | Select Case | Do…Loop
Using the debug window | Starting, halting and tracing execution | Resolving compile and run-time errors | Working with breakpoints
On error statement | Resume points
Delegates will be encouraged to write their own VBA code to help them learn and appreciate what they are doing
Simply complete the form below and we'll come back to you as soon as possible