Unanswered Questions
364 questions with no upvoted or accepted answers
31
votes
0
answers
1k
views
Pacman implemented in OOP VBA
What?, Why?
I have been inspired by several other posts on the topic of OOP implementations in VBA to try and create a Pacman clone. I think this task is not all that hard in most languages; but, I ...
- 29.1k
20
votes
0
answers
1k
views
Progress Bar for Excel
Any future updates can be found at Excel-VBA-ProgressBar
What I've been using so far
For the last 6 years I've been using a progress form which I wrote in VBA using just Windows API calls. The code (...
18
votes
0
answers
386
views
Modularizing a Game Scene in Sprite Kit
I am trying to modularize the main SKScene of my strategy game. I am not sure that my approach is correct so I would love to get a review of the following code.
...
- 12k
14
votes
0
answers
584
views
BattleShip - Ships & Players
I'm making a full-blown OOP Battleship game in VBA (previous post: Battleship Grid), and I want this code to be as good as it gets - and better, if I can.
I've refactored a few things, introduced a <...
- 75.3k
13
votes
0
answers
404
views
Faster VB6 / VBA class deallocation
For latest additions, see Edit sections at the bottom of this question.
VB6 / VBA is slow to deallocate class instances
VB* class instance deallocation becomes exponentially slower the more instances ...
- 1,696
11
votes
0
answers
360
views
Host-Agnostic Model-View-ViewModel Infrastructure
I've written an API that unlocks some serious MVVM capabilities with VBA's MSForms UI framework.
This is the complete code-behind for an example ...
- 75.3k
11
votes
0
answers
2k
views
Function to conect to Firebase Rest API via Access VBA
This is the application for small school, which will store students' info in Firebase and also retrieve data from Firebase. I am using JSON Parser to parse the data and save the same in Access tables.
...
- 2,471
10
votes
0
answers
2k
views
Private VBA Class Initializer called from Factory #2
About
This is a follow-up of a previous question Private VBA Class Initializer called from Factory. I've decided to create a new question instead of answering my old question because I would like the ...
- 1,696
10
votes
0
answers
2k
views
Geode Contents Predictor StardewValley Mod
The goal
I really enjoy the game Stardew Valley. One of the things that the game has are geodes. Much like real-world geodes, these geodes can be cracked open, and you can find some fun things inside....
- 8,064
9
votes
0
answers
568
views
Hunt the Wumpus GUI (FLTK)
I used the code from the text based hunt the wumpus game discussed here: Text based game “Hunt the Wumpus” Version 3 to create a gui Version based on excercises from PPP by Stroustrup.
For the GUI i ...
- 145k
8
votes
0
answers
808
views
A VBA program to quantify the performance of code execution timers
Motivation
I am interested in optimising the execution time of code with short (fast) execution times on the order of microseconds (µs), but that will be used with high frequency (e.g. like ...
- 181
8
votes
0
answers
4k
views
Responding to Events of Dynamically added Controls
I was asked for an example of a class to wrap dynamically added controls as I suggested in this Answer. Although it is out of the context of a Code Review, I thought that it would make an interesting ...
- 4,308
8
votes
0
answers
805
views
Battleship MVC Architecture
The entry point is the Macros module, which - for now - includes only a single procedure, at a very high abstraction level - I'm quite happy with this:
...
- 75.3k
8
votes
0
answers
1k
views
IndexedArray Class: Uses a Dictionary Keys to Index a 2 Dimensional Array of Values
This class encapsulates a 2D Array and a Scripting Dictionary. Values are add or returned from to the Array using a Key and a ColumnIndex, e.g. ...
- 4,308
8
votes
0
answers
3k
views
Bringing The System.Text.StringBuilder Up To Lightning Speed In The VBA
After having to swap the feature rich System.Text.StringBuilder for the very fast but very vanilla A lightning-fast StringBuilder, I decided it was time create a ...
- 4,308