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...
