Click here to Skip to main content
15,040,729 members
Everything / VBA

VBA

VBA

Great Reads

by William Hey
Classical number theories
by bradyguy
An end to end view of how to integrate Jira REST API's with Excel.
by RB Starkey
How to create a tree-view control using an Access table and form.
by William Hey
Semi-Prime Ordered Sequences (Part 2) is the follow-on to “Exploring Computational Number Theory (Part 1)” and describes a process for ordering the semi-prime base sequences.

Latest Articles

by ChrisK23
A method to automate Chrome (based) browsers using VBA
by VisualMonsters
Simple game "table football", you can easily create and play with your friends and family
by VBA55
Display data in chart as Speedometer or Thermometer graphic
by VBA55
Helping to add VBA project build in Access to SVN

All Articles

Sort by Score

VBA 

Please Sign up or sign in to vote.
12 Apr 2016
bradyguy
An end to end view of how to integrate Jira REST API's with Excel.
Please Sign up or sign in to vote.
16 Jul 2013
RB Starkey
How to create a tree-view control using an Access table and form.
Please Sign up or sign in to vote.
31 May 2016
William Hey
Semi-Prime Ordered Sequences (Part 2) is the follow-on to “Exploring Computational Number Theory (Part 1)” and describes a process for ordering the semi-prime base sequences.
Please Sign up or sign in to vote.
26 Mar 2019
Igor Krupitsky
This program will convert office, text and image files to PDFs.
Please Sign up or sign in to vote.
6 Jul 2021
VisualMonsters
Simple game "table football", you can easily create and play with your friends and family
Please Sign up or sign in to vote.
8 Mar 2012
Torsten Tiedt
Avoid event spaghetti code when business logic becomes complex.
Please Sign up or sign in to vote.
24 Jun 2014
Bhis
Back in 2008, I was doing some freelance work and had a chance to work on this MS Access Report project. The client dealt with employee benefits, claims, and payment reimbursements.
Please Sign up or sign in to vote.
27 Jul 2012
Kudredin
Making use of the User Defined Fields to help better organize emails, and keep track of informaiton
Please Sign up or sign in to vote.
9 Nov 2014
Allen C. Copeland Jr
A guide on querying Excel ListObjects (Tables) by creating a state-machine out of synthesized objects that resemble a query language.
Please Sign up or sign in to vote.
21 Jun 2016
Dave “DWC” Curry
This tutorial will show you a good starting point for a WPF style framework which aims to make creating and maintaining Excel-worksheet-forms easier.
Please Sign up or sign in to vote.
1 Feb 2021
Gustav Brock
Format amounts in VBA using the Indian number format for currency and amounts
Please Sign up or sign in to vote.
5 Jan 2012
Sam Gerené
Create a custom dockable window in the VBA editor.
Please Sign up or sign in to vote.
26 Aug 2014
Koen Vingerhoets
Add and handle MSGraph in PowerPoint slides
Please Sign up or sign in to vote.
18 Sep 2018
Randy C Finch
A search for efficient algorithms to find Ruth-Aaron pairs
Please Sign up or sign in to vote.
1 Mar 2020
NewPast
Indent code, add line numbers, err handling, Add number to words and more, Expose a .NET library to Microsoft Word, Excel, Power Point macros writers and Access VBA code
Please Sign up or sign in to vote.
22 Aug 2014
Thomas Roll
Developing custom functionality for Microsoft Office 2011 for Mac in C and VBA
Please Sign up or sign in to vote.
8 Jan 2014
Mark Regal
It is the intention of this article to add a measure of detail to all user defined enumerations through the creation of an enumeration database.
Please Sign up or sign in to vote.
31 Dec 2013
Mark Regal
This article is intended to build on the extensibility knowledge base with a focus on deconstructing a VBA code module.
Please Sign up or sign in to vote.
24 Oct 2014
Tim Ski
JSON parser for VBA class module, allows recursive data
Please Sign up or sign in to vote.
2 Mar 2011
Joel C Graff
A method for instantiating classes using Reflection.
Please Sign up or sign in to vote.
1 Apr 2017
NewPast
Floating point numbers as approximates and understanding error happened when using single and double data types
Please Sign up or sign in to vote.
2 Mar 2017
Dracula
VBA Macros Provide Yahoo Stock Quote Downloads in Excel 2007
Please Sign up or sign in to vote.
3 Jun 2013
StewBob
This article gives a method for using Excel VBA to convert discrete data points into a histogram.
Please Sign up or sign in to vote.
10 Mar 2014
EiadXP
This is a very fast way to access string (or other) data with minimum memory consumption.
Please Sign up or sign in to vote.
7 Mar 2012
Yiannis Spyridakis
This articles describes the implementation of functors (of sorts) for VBA using C++ ATL.
Please Sign up or sign in to vote.
15 Jan 2013
Marco Sorich
Some guidelines for developing better MS Access solutions.
Please Sign up or sign in to vote.
16 Jul 2010
E.F. Nijboer
Source code for saving mail items to separate files and keeping folder structure
Please Sign up or sign in to vote.
2 Mar 2011
Won Dong
To utilize cloud service as an anonymous desktop environment in Amazon S3 and EC2 Windows instances
Please Sign up or sign in to vote.
3 Sep 2013
Eric Reynolds
ExcelPython is a lightweight COM library which enables you to call Python code and manipulate Python objects from Excel VBA.
Please Sign up or sign in to vote.
26 Jan 2015
Alexandros Pappas
This article proposes a way to do book-keeping for home use.
Please Sign up or sign in to vote.
24 Feb 2019
WhiskeyBeforeWater
An unbalanced basic recursive Binary Search Tree for Excel VBA with functions (insert, search, delete, in order, pre-order, post-order, minimum, and maximum)