Unanswered Questions
396 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 (...
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
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
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
7
votes
0
answers
357
views
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
6
votes
0
answers
112
views
Shape Text Formatter Class a Builder Pattern
The preeminence is to have every method of the formatter return the formatter as a reference. This allows it to add and format text in chain. Such as:
...
- 4,308
6
votes
0
answers
133
views
An over-the-top approach to data entry
My goal: to make the already easy task of filling out an excel sheet 1% easier by putting in hours and hours of effort. On a more serious note, I'm currently developing a system to manage inventory at ...
- 133
6
votes
0
answers
642
views
Office CommandBarButton Icon Browser in the VBEditor
Frustrated with the solutions that I found online I decided to write my of Icon Browser. From the onset I decided that my Icon Browser should work from the VBEditor and not show any of the thousands ...
- 1
5
votes
0
answers
42
views
Excel Bookkeeping Application, Create Ledgers from Chart of Accounts and Journal
I am writing an Excel bookkeeping application that would be suitable for a small business or contractor. The application is based on a book on double entry bookkeeping:
https://www.amazon.co.uk/gp/...
- 2,509
5
votes
0
answers
69
views
Excel Lambdas for Filtration Lookup
Background
I have an ongoing challenge in Excel, where I must match differing descriptions of the same object. Originally, there were only two alternatives:
Use a dropdown list in Excel, which pulls ...
- 521