This article provides a highlevel overview of how and why to integrate VBA in Crystal Ball spreadsheet models. Given that Oracle Crystal Ball runs on Excel, it is worth exploring how VBA can create behaviors that are NOT natural to Excel!
For almost 15 years we have been witnessing a fundamental shift in how we do business, how we live and how we envision the world. Some have referred to this as a Paradigm Shift (Senge, 1991) brought on by cheaper and more accessible technologies (Ashkenas et al. 1995). As business people, we are constantly faced with solving problems and driving results, but that task is becoming more difficult because the lay of the land has changed and is going to continue to change – for everybody and every industry.