Select Page

Excel Video 440 Custom Functions Part 2

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

Excel Video 439 Custom Functions Part 1

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

Excel Video 438 Case Statements

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