Click here to Skip to main content
14,389,999 members
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 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.
by LukeCodes
This is a simple macro script to search and retrieve individual cells in an Excel document.

Latest Articles

by NewPast
Indent code, add line numbers, error handling, expose a .NET library and number to words to Microsoft Word, Excel, Power Point macros writers and Access VBA code
by NewPast
Excel, Pure VBA Macro: Molecular Weight/Molecular Mass Calculator
by Member 12994860
Change the Font Color of all Equations in a Word Document
by Igor Krupitsky
This program will convert office, text and image files to PDFs.

All Articles

Sort by Score

VBA 

12 Apr 2016
bradyguy
An end to end view of how to integrate Jira REST API's with Excel.
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.
16 Jul 2013
RB Starkey
How to create a tree-view control using an Access table and form.
26 Mar 2019
Igor Krupitsky
This program will convert office, text and image files to PDFs.
8 Mar 2012
Torsten Tiedt
Avoid event spaghetti code when business logic becomes complex.
18 Aug 2017
VisualMonsters
Simple game "table football", you can easily create and play with your friends and family.
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.
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.
27 Jul 2012
Kudredin
Making use of the User Defined Fields to help better organize emails, and keep track of informaiton
22 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.
19 Sep 2018
Randy C Finch
A search for efficient algorithms to find Ruth-Aaron pairs
31 Aug 2019
NewPast
Indent code, add line numbers, error handling, expose a .NET library and number to words to Microsoft Word, Excel, Power Point macros writers and Access VBA code
22 Aug 2014
Thomas Roll
Developing custom functionality for Microsoft Office 2011 for Mac in C and VBA
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.
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.
2 Apr 2017
NewPast
Floating point numbers as approximates and understanding error happened when using single and double data types
24 Oct 2014
Tim Ski
JSON parser for VBA class module, allows recursive data
2 Mar 2011
Joel C Graff
A method for instantiating classes using Reflection.
3 Mar 2017
Dracula
VBA Macros Provide Yahoo Stock Quote Downloads in Excel 2007
3 Jun 2013
StewBob
This article gives a method for using Excel VBA to convert discrete data points into a histogram.
10 Mar 2014
EiadXP
This is a very fast way to access string (or other) data with minimum memory consumption.
7 Mar 2012
Yiannis Spyridakis
This articles describes the implementation of functors (of sorts) for VBA using C++ ATL.
15 Jan 2013
Marco Sorich
Some guidelines for developing better MS Access solutions.
16 Jul 2010
E.F. Nijboer
Source code for saving mail items to separate files and keeping folder structure
10 Jun 2019
NewPast
Excel, Pure VBA Macro: Molecular Weight/Molecular Mass Calculator
2 Mar 2011
Won Dong
To utilize cloud service as an anonymous desktop environment in Amazon S3 and EC2 Windows instances
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.
26 Jan 2015
Alexandros Pappas
This article proposes a way to do book-keeping for home use.
5 Jan 2012
Sam Gerené
Create a custom dockable window in the VBA editor.
26 Aug 2014
Koen Vingerhoets
Add and handle MSGraph in PowerPoint slides
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)