All Questions
4 questions
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
18
votes
2
answers
4k
views
Using events together with interfaces in VBA
Introduction
Because of the limitation of VBA in using events in interfaces I was searching for a kind of workaround.
For sure I also read this which also provides an approach, but I was searching for ...
- 428
31
votes
1
answer
4k
views
Unit Testing in VBA
Unit testing in VBA is... lacking. (What isn't lacking in VBA though?) Since I've become more interested in unit testing lately, I decided I needed something better than ...
- 31.1k