This video shows some techniques that are vital when you write VBA code. Firstly it shows you how to use the InputBox function to ask users questions as your code runs (like a message box with a text entry cell it the form).
It then goes on to show you how to use the IF statement which is probably the function you will use the most within your routine. However there are some times when there are too many options to write everything in IF statements and this is when you will need to use a SELECT CASE statement.
The SELECT CASE statement is covered at the 9 minute mark – so if you already know about the IF statement you can simply jump to the SELECT CASE part of the video.
If you have found this video useful please like or share the video using the buttons above, or leave us a comment below.