Excel VBA

Excel VBA Event Procedures

October 6, 2015 0

Excel VBA Introduction Part 20 – Event Procedures DESCRIPTION Writing Event Procedures allows you to create subroutines which run automatically in response to events in a workbook. This video teaches you how to access the […]

Excel VBA

Excel VBA Error Handling

September 29, 2015 0

Excel VBA Introduction Part 19 – Error Handling DESCRIPTION Almost every procedure you write in VBA has the potential to go wrong at some point! Writing error handling code allows your procedures to fail gracefully […]

Excel VBA

Excel VBA Creating Functions

September 22, 2015 0

Excel VBA Introduction Part 18 – Creating Functions DESCRIPTION A VBA function is a procedure that can return a value and this video teaches you how to create them. You’ll learn how to declare a […]

Excel VBA

Excel VBA For Each Loops

September 15, 2015 0

Excel VBA Introduction Part 17 – For Each Loops DESCRIPTION A For Each Loop is used to loop over a collection of objects and there are lots of good reasons for wanting to do that […]

Excel VBA

Excel VBA For Next Loops

September 8, 2015 0

Excel VBA Introduction Part 16 – For Next Loops DESCRIPTION You can use a For Next Loop to tell your program to repeat a set of instructions a number of times. This video teaches you […]

Excel VBA

Excel VBA Find and FindNext

September 1, 2015 0

Excel VBA Introduction Part 15a – Find and FindNext DESCRIPTION You can use the Find and FindNext methods in Excel VBA to find values in a worksheet – exactly as the name suggests! This video […]

Excel VBA

Excel VBA Do Until and Do While Loops

August 25, 2015 0

Excel VBA Introduction Part 15 – Do Until and Do While Loops DESCRIPTION Do Loops in VBA allow you to carry out a set of instructions repeatedly until some kind of condition is met. This […]

Excel VBA

Excel VBA Select Case Statements

August 18, 2015 0

Excel VBA Introduction Part 14 – Select Case Statements DESCRIPTION Select Case statements in VBA are similar to If statements in that they allow to test whether conditions are met and perform different actions based […]

Excel VBA

Excel VBA If Statements

August 11, 2015 0

Excel VBA Introduction Part 13 – If Statements DESCRIPTION An IF Statement allows you to test whether a condition is met and then perform different actions based on the result. This video takes you from […]

Excel VBA

Excel VBA With Statements

August 4, 2015 0

Excel VBA Introduction Part 12 – With Statements DESCRIPTION A With Statement in VBA is a great way to make your code a lot neater and a bit more efficient. This short video shows you […]