Further Details
Revision of Level 1
· VBE Components
· If Statements
· With…
Continuing Sub Procedures
· Revisiting the scope of Variables
Dim
Public dim
Const
Public const
· Understanding Events
· User Input
A simple form
Inputbox and Msgbox
Using Worksheet Data
Providing a browse for a file box
Providing a GetSaveAsFileName box to save a file
· Using Select Case vs using If statement
· Expanding on Conditional Formatting limitations
Looping
· For Each cell in range… etc
· Do While… Loop
· Do Until… Loop
· For a = 1 to 50 etc
Error Handling
· Setting and going to Bookmarks
· Catching Errors
· On error goto….
· On Error Resume Next
· On Error goto 0
Functions
· Using Built in VBA Functions
Working out differences in dates (Datediff, etc)
Extracting info from a long string (trim, left, right, mid, instr)
Working out what kind of value is residing in a cell (isnumeric, isstring, isdate… etc)
· Creating your own Functions
A value with VAT added to it
Returning a country based on a provided city
Returning the last cell address in a range
Returning the last row in a range
Returning the last column in a range
Guide price
£150 |
