by Nate Moore | Nov 24, 2014 | Macros and VBA
The pre-authorization example gets even more precise in Excel Video 437, the last Excel Video about If. We’ll add several different tests to make different pre-authorization scenarios different colors in this Excel Video, including And tests and Or tests. We’ll also...
by Nate Moore | Nov 17, 2014 | Macros and VBA
You can add more power to your If statements by using Else and ElseIf. Excel Video 436 has an example of both. The If statements we worked through in the last Excel Video tested to see if the insurance was not Medicare. If the insurance is Medicare, we can use an Else...
by Nate Moore | Nov 10, 2014 | Macros and VBA
Adding If statements makes your code much more powerful. I’ll show you how to start using If statements in Excel Video 435. We’ll work through two examples to start. The first example is a simple If statement that fits on one line. Notice the If clause contains a test...
by Nate Moore | Nov 3, 2014 | Macros and VBA
In Excel Video 434 we’ll work through how to capture user input from Message Boxes. Notice how the syntax is slightly different when we need the user’s answer. We define a variable as equal to the Message Box and the Message Box function now needs parentheses. The...
