Unanswered Questions
235 questions with no upvoted or accepted answers
30votes
0answers
1kviews
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 ...
23votes
0answers
447views
Mucheck - a mutation analysis tool for Haskell programs
We have been working on a mutation analysis tool for Haskell tests called MuCheck. It accepts any Haskell source file, and a function name to mutate, applies a defined set of mutation operators on it, ...
20votes
0answers
2kviews
Progress Bar for Excel
Any future updates can be found at Excel-VBA-ProgressBarWhat I've been using so farFor the last 6 years I've been using a progress form which I wrote in VBA using just Windows API calls. The code (...
14votes
0answers
603views
Faster VB6 / VBA class deallocation
For latest additions, see Edit sections at the bottom of this question.VB6 / VBA is slow to deallocate class instancesVB* class instance deallocation becomes exponentially slower the more instances ...
14votes
0answers
610views
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<...
11votes
0answers
386views
Host-Agnostic Model-View-ViewModel Infrastructure
I've written an API that unlocks some serious MVVM capabilities with VBA'sMSForms UI framework.This is the complete code-behind for an example ...
11votes
0answers
2kviews
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....
10votes
0answers
2kviews
Private VBA Class Initializer called from Factory #2
AboutThis 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 ...
8votes
0answers
850views
A VBA program to quantify the performance of code execution timers
MotivationI 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 ...
8votes
0answers
4kviews
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 ...
8votes
0answers
857views
Battleship MVC Architecture
The entry point is theMacros module, which - for now - includes only a single procedure, at a very high abstraction level - I'm quite happy with this:...
8votes
0answers
1kviews
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 aColumnIndex, e.g. ...
8votes
0answers
3kviews
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 ...
7votes
0answers
5kviews
Cubic spline interpolation in Python from scratch
I implemented the cubic spline interpolation explained inhttps://en.wikipedia.org/wiki/Spline_interpolation as a Python class. Of course, such an interpolation should exist already in some Python ...
7votes
0answers
394views
Web Battleship -The Unofficial Battleship UI
I've written my own UI for Mathieu Guindon's VBA Battleship (Battleship UI: GameSheet) which uses a webpage in a WebBrowser control for the View.Webform:Userform...
CommunityBot
- 1





