xlCubeSuper An Excel Game Explained – Part2

In Part1, the new version of xlCube (now referred to as xlCubeSuper) was introduced.

https://dhexcel1.wordpress.com/2018/01/19/xlcubesuper-an-excel-game-explained-part1/

In Part2, I will describe the different techniques to make this game application work. But, before I do, I think that it is important to point out that the game is not tied down tight. For example, there is no workbook-level protection. If users wanted to, they could damage the integrity of the game by adding or deleting worksheets (if they saved the changes). So, the game is not tamper-proof and was never intended to be. Rather, it was made as a game to be enjoyed and an application to learn from. Here then is a list of the major techniques to be discussed.

  • 3D formulas
  • Defined named formulas
  • Conditional formatting formulas
  • Formulas to aggregate shots and hits
  • Use of VBA to:
  1. Add 3D ranges
  2. Shoot using VBA event procedure.
  3. Create and delete non-ribbon (old style) menus.
  4. Store and sort game scores.
  5. Control the formatting of shots and hits.
  6. Display information and results.

The backbone of this game is the 3D formulas created to define virtual cubes and the center of those cubes. We will see in a later post how these formulas are generated through VBA, but for now, here is what they look like as shown in Name Manager.

xlCS2_3Dformulas

In Part3 we will see how these formulas are created in random locations by VBA.

Advertisements

1 thought on “xlCubeSuper An Excel Game Explained – Part2

  1. Pingback: xlCubeSuper An Excel Game Explained – Part3 | Excel For You

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s