| CARVIEW |
Select Language
HTTP/2 200
date: Sun, 27 Jul 2025 08:31:43 GMT
content-type: text/html; charset=utf-8
cf-ray: 965ac8339d88ccbb-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=5ce3c5b5-31c0-4528-beb8-1da96d2f8a9f; expires=Mon, 27 Jul 2026 08:31:43 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: 21b59d16-0240-4ca4-9c6e-6600370aea93
x-worker-origin-response-time: 1147000000
x-dns-prefetch-control: off
set-cookie: prov=5ce3c5b5-31c0-4528-beb8-1da96d2f8a9f; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=mHTYS1skTpaHMdI2_wn7P6ib1HbuMq_YzGqVjSC43fQ-1753605103-1.0.1.1-hk7Cfzy8NN8Vbo5OhAhxKYYDlkPV9AeT44S1fcG9jUUEUwhwwnVMryfrHXFG8PNhEBaZko1RIljRscAq87KvLVpMGTc9jUnLkOwfiikgB9U; path=/; expires=Sun, 27-Jul-25 09:01:43 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=8hJYUskARLjgX8gPTKw9qbUQpWIITkUKwNst_7RdiFE-1753605103814-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'vba' Questions - Code Review Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [vba]
Visual Basic for Applications (VBA) is an event-driven programming language first introduced by Microsoft in 1993 to give Excel 5.0 a more robust object-oriented language for writing macros and automating the use of Excel. It is now used for the entire Office suite and over 200 non-Office hosts.
1,292 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
6
votes
1
answer
94
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/...
12
votes
0
answers
458
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,686
7
votes
2
answers
293
views
VBA: Efficiently Organise Data with Missing Values to Achieve Minimum Number of Tables
The task is to create sub-tables from an original table (like below) that contain the missing data columns (missing data is highlighted in red). The important part of this task is to make the smallest ...
3
votes
1
answer
146
views
VBA code used to build a diverse portfolio of DFS lineups to minimize risk
This code works great and does exactly what I want but it takes around 10 minutes for the code for find 150 lineups. I am hoping to get help and learn how to make it much faster.
The goal of this code ...
3
votes
0
answers
118
views
Evaluating WinAPI, PowerQuery, PowerShell, and FileSystemObject for File Retrieval Using VBA
Traditionally, VBA developers rely on the FileSystemObject to retrieve files within a directory. I decided to test and compare different methods (Windows API, PowerQuery, PowerShell, and ...
3
votes
1
answer
110
views
Search through all the sub-folders in a given folder for files
I use the below code to loop through a list of data and search through all the sub-folders in a given folder for files which match my requirements.
Right now it takes this code about 22 minutes to run,...
3
votes
0
answers
188
views
Simulating Objects with Collections in VBA
Background
I am writing a VBA module which requires the functionality of a custom object. This object will support "regular" functions (UDFs) within the module.
Due to reasons beyond the ...
4
votes
1
answer
142
views
Speed up recursively looping through network folder and subfolders in VBA
I'm trying to loop through around 100k files in varying degrees of nested directories using vba and md5 hashing each of those files. Right now, the current state of the program takes around 1.5 to 2 ...
5
votes
1
answer
133
views
Update Member "In Place" within VBA Collection
Background
I encountered this issue a while back, where I tried to "set" the value of a member "in place", without changing its position within the ...
- 511
4
votes
0
answers
374
views
Fluent VBA: Two (Almost Three) Years Later
Part 1 - A fluent unit testing framework in VBA: A fluent unit testing framework in VBA
Part 2 - Fluent VBA: One Year Later: Fluent VBA: One Year Later
Two (almost three) years have now passed since I ...
-1
votes
1
answer
70
views
Need assistance modifying a "too large" procedure [closed]
I have a chunky VBA script that needs some help making it efficient, which I think will correct the "Procedure too Large" issue I just ran into.
I run the procedure from an open workbook ...
-3
votes
1
answer
61
views
Multiple key swap algorithm [closed]
I have a dictionary with key - data pairs. My data comes from excel sheets. When I create the dictionary my objects are placed in order by their keys ex. 1 -> data of sheet1, 2 -> data of sheet2 ...
2
votes
1
answer
201
views
Which is faster: Unhide rows during IF or Unhiding them all at once in another macro?
I have process where I am generating workbooks from a list. One of the tabs has varying height and I have a formula that my macro uses to determine whether to hide a row.
As I move to the next ...
5
votes
0
answers
181
views
A new Dictionary for VBA
The latest version of the Dictionary class presented in this question is available in the VBA-FastDictionary repository under the latest release.
Motivation
I ...
- 1,686
3
votes
1
answer
150
views
userform with textboxes and dates to show timeline
I am writing the following VBA code to make a timeline, which I will be using for other parts of the code later on for other calculations and output. I have a userform where the following number of ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
excel × 879
performance × 263
beginner × 87
object-oriented × 85
array × 56
ms-access × 47
web-scraping × 35
error-handling × 33
strings × 28
sql × 26
ms-word × 25
rubberduck × 25
time-limit-exceeded × 24
vb6 × 24
algorithm × 22
datetime × 19
adodb × 19
hash-map × 19
file-system × 18
sorting × 18
unit-testing × 18
collections × 16
winapi × 12
design-patterns × 11
game × 11
more related tags
Hot Network Questions
- Balancing a Holy Water Bomb
- Source for Adam naming the angels
- Did the first sin in the garden of Eden actually take place before the fruit was eaten?
- spots / stains on tubeless tire
- Is this a violation of open source?
- How much of a really big a spaceship could a nuke take out?
- Kepler's first law proof error - can anyone help me see what the error is?
- I am looking for a French mathematician who contributed to complex analysis
- Anonymizing a submission for double-blind review
- Rec Letter from Professor (who I haven't done research with) or from Work Supervisor
- How can I turn the text in a PNG file back into text layer?
- What is the citation for Augustine's "consensus, non concubitus..."
- When did the OEIS get even better?
- rock paper scissors game with randomized system choices. NOT using rnd()
- Early Sailing days in September 1066... Could Harold defeat William at Hastings, if it happened before Stamford Bridge?
- Why does the node Bounding Box suddenly produce a different result in version 4.5?
- "I met a monk and philosopher." How many people did I meet?
- Lay explaination of 'lower evolutionary constraint genes'?
- Book recommendations for theistic books about God's existence
- A national poll of 1000 French returns 25% of "Yes". Is it enough to say that it's quite impossible locally to be 0%, if we don't know the variance?
- Existence of Jordan curves between a compact and an open set
- Confusing/incorrect sentence in proof of Zorn's Lemma in Lang's "Real and Functional Analysis"
- The Russian president is struggling to pass a law now. Then, how much power does Kremlin have to initiate a congressional decision?
- Extensions of diagonalizable, respectively multiplicative-type, groups