by Nate Moore | Dec 15, 2014 | Macros and VBA
The final video of 2014 and the final video in our series on VBA and macros is a practical example for medical practices. We’ll build a custom Aging function in Excel Video 440 using a case statement. Once all of the pieces are in place, the Aging function is pretty...
by Nate Moore | Dec 8, 2014 | Macros and VBA
Excel Video 439 puts several of the things we’ve learned over the past Excel Videos together to build a custom function in VBA. The custom function is a response to a question a while back in MGMA’s Excel Users group asking for a way to compare the fill color of...
by Nate Moore | Dec 1, 2014 | Macros and VBA
Excel Video 438 introduces case statements, which are a more concise and easier to read way to express multiple options in VBA. Notice how the Case statement starts with Select Case and ends with End Select and how the Case statement fits inside the loop so that each...
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...
