Examples from arkham46.developpez.com: VBA was used to run OpenGL, create games using GDI+ and create interactive infographics!
In this GitHub I want to share examples from web site of Thierry Gasperment. Although all samples and descriptions are open source, you have to register on the web site. Nevertheless, it's worth to register if you want to go deeper into details because the site contains tons of very helpful info. To translate the site I recommend Chrome.
[Original tutorial (11 lessons) can be read here, no authorization is necessary]. The last lesson contains a collection of examples:
- [VBA modules for OpenGL (original link, authorization necessary)] [GitHub]
- [FreeGLUT library (original link, authorization necessary)] [GitHub]
- [Demo with using of FreeGlut (original link, authorization necessary)] [GitHub]
- [Demo without using of FreeGlut (original link, authorization necessary)] [GitHub]
Example:
Thierry has created two descriptions on how to add GDI+ to VBA: original link, no authorization necessary and original link, no authorization necessary.
And now the classic games!
[GitHub], [original link, authorization necessary]
[GitHub], [original link, authorization necessary]
Use mouse to move. Space to fire.
[GitHub], [original link, authorization necessary]
Use arrows to move the space ship. "Ctrl" to fire. The second player must use joystick. The original link contains a small error: In the "RunGame" ("clGame" class) subroutine I changed "config" to "data/config". The GitHub version contains corrected version.
[GitHub], [original link, authorization necessary]
Use arrows to move the space ship. Space to fire.
A step-by-step description of Pacman VBA code exist in (original link, no authorization necessary).
If you want to start the game immediately: [GitHub], [original link, authorization necessary]
Use arrows to move the Pacman.
For infographics it is very useful to have a map to show the statistic. A step-by-step description of creating of map of France with departments is shown in the link: original link, no authorization necessary. The map of France is created from the paths in column A. The easiest way to create paths is to copy them from SVG file. The function "ImportSVG" opies paths from the "[Départements_et_régions_de_France.svg]" (must be in the same folder as the table) to the column A. The map should be deleted before. You can also repaint the map by using the function "CreateShapes" that uses paths' in column A. The map should be removed in this case either.
An example can be downloaded from here: [GitHub], [original link, authorization necessary].
[GitHub], [original link, authorization necessary]
In an example of interactive infographics the department is painted green if its value in 2009 was above the value of 2008. Otherwise it will be painted red. Actually, no refreshment button is necessary.
[GitHub], [original link, authorization necessary]
And finally, the "Game of departments". The purpose of the game is to click the correct department (shown in cell "C2") on the map. In case of error clicked department is shown in cell "C3". The current count is presented in cell "C4".
