All Questions
35 questions
4
votes
0
answers
418
views
A vehicle database in Excel
I'm looking for some help. I'm new to coding and have started creating this Vehicle database program in Excel for a friend to use.
He is wanting to be able to see all vehicles he owns, when ...
5
votes
1
answer
158
views
Copy Columns Forward Macro: From Procedural to OOP
Background: I had created a macro few years ago and when I was reviewing this now, it was hard to understand.
I recently went through all the articles from ...
- 163
2
votes
0
answers
83
views
Modeling data from Excel sheets to parse to Excel sheet
Background:
I have close to 50 excel files - I cannot change the data source - and I steadily get more.
My task is to make sense of all that data and, lo an behold, save that as another excel file (I ...
- 121
6
votes
1
answer
184
views
Creating a Chart Worksheet from scratch with VBA / OOP Design
I recently posted some code for review, and am now looking to gather some feedback on my latest implementation with that code. Yes, I have fallen into the OOP rabbit hole (thanks Mathieu Guindon) and ...
- 113
3
votes
0
answers
85
views
Setting a forecast for 2,5k workers intraday for a whole month
I'm working on a large project that requires a ton of data to be processed. I was thinking that using classes would be the best way, and it is, until it has to dump out the memory at the end of every ...
- 188
6
votes
0
answers
135
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
0
votes
0
answers
159
views
Managing Excel Tables (ListObjects) with OOP Approach (Second follow up)
This is a follow up to this question and this question
Objective:
Manage what happens when users interact with Excel Tables (ListObjects)
Code incorporates:
...
- 413
4
votes
1
answer
832
views
Implementing a class hierarchy and instancing the base class in VBA
Objective:
Have a single point of entrance to initialize a class that holds instances of "sub" classes
Background:
I read about inheritance in VBA (or as close as ...
- 413
1
vote
1
answer
201
views
VBA Class instance to simulate a framework
Objective:
Simulate namespaces in VBA and access functions like if you had a Framework setup or at least that was what I ...
- 413
3
votes
1
answer
799
views
Managing Excel Tables (ListObjects) with OOP Approach (Follow up)
This is a follow up to this question
Objective:
Manage what happens when users interact with Excel Tables (ListObjects)
Code incorporates:
Greedo's answer suggestions:
Listen to an encapsulated <...
- 413
5
votes
1
answer
663
views
Managing Excel Tables (ListObjects) with OOP Approach
Objective:
Manage what happens when users interact with Excel Tables (ListObjects)
Possible interactions:
Update an existing Excel table
Add rows/columns to the table
Update a cell or a range of ...
- 413
4
votes
1
answer
308
views
OOP Dependency inversion principle VBA
I've reproduced the example of this video where dependency inversion principle is explained by Tim Corey based on C#
I had some trouble understanding the scope of the Logger and MessageSender ...
- 413
5
votes
1
answer
205
views
Manage Excel Styles with VBA OOP Approach (Follow up)
This is a follow up to this question
Code incorporates Mathieu's comments and it works. As some parts of the review left some code to my knowledge, I ask for another review to see if I implemented ...
- 413
5
votes
1
answer
272
views
Manage Excel Styles with VBA OOP Approach
I want to manage the Excel Styles in a more flexible way with bulk actions and at the same time improve my newly acquired OOP concepts.
Objectives:
Load the current Styles list (name and type=builtin ...
- 413
3
votes
0
answers
154
views
Rich data types - boolean object
Context
You can probably skim most of this, it's unlikely to be useful for a review and is just for background info. Also download the files
I've tried to create a ...
- 2,625