Click here to Skip to main content
15,917,618 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 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
by NewPast
Floating point numbers as approximates and understanding error happened when using single and double data types
by Patrice T
The Excel Tools I crafted to simplify my life as programmer
by Mirzakhmet Syzdykov
Development process in few steps with the help of scripting software

All Articles

Sort by Score

VBA 

12 Apr 2016 by bradyguy
An end to end view of how to integrate Jira REST API's with Excel.
16 Jul 2013 by RB Starkey
How to create a tree-view control using an Access table and form.
31 May 2016 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.
6 Jul 2021 by VisualMonsters
Simple game "table football", you can easily create and play with your friends and family
26 Mar 2019 by Igor Krupitsky
This program will convert office, text and image files to PDFs.
31 Oct 2022 by Wayne Jin
A walkthrough to create a count down timer Add-in for Powerpoint
8 Mar 2012 by Torsten Tiedt
Avoid event spaghetti code when business logic becomes complex.
24 Jun 2014 by 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.
27 Jul 2012 by Kudredin
Making use of the User Defined Fields to help better organize emails, and keep track of informaiton
9 Nov 2014 by 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.
4 Oct 2022 by junyaoxu
Step by step implementation of DCOM real time stock quote server with Yahoo financial API
6 Dec 2022 by Wayne Jin
Extend the function of Microsoft Office and Python
21 Jun 2016 by 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.
1 Feb 2021 by Gustav Brock
Format amounts in VBA using the Indian number format for currency and amounts
5 Jan 2012 by Sam Gerené
Create a custom dockable window in the VBA editor.
26 Aug 2014 by Koen Vingerhoets
Add and handle MSGraph in PowerPoint slides
27 Jul 2023 by Patrice T
The Excel Tools I crafted to simplify my life as programmer
18 Sep 2018 by Randy C Finch
A search for efficient algorithms to find Ruth-Aaron pairs
16 May 2022 by Excel-lent
This article shows how to compile and execute OpenCL code from VBA.
4 Sep 2023 by 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
22 Aug 2014 by Thomas Roll
Developing custom functionality for Microsoft Office 2011 for Mac in C and VBA
8 Jan 2014 by 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.
19 Aug 2023 by NewPast
Floating point numbers as approximates and understanding error happened when using single and double data types
31 Dec 2013 by Mark Regal
This article is intended to build on the extensibility knowledge base with a focus on deconstructing a VBA code module.
24 Oct 2014 by Tim Ski
JSON parser for VBA class module, allows recursive data
2 Mar 2011 by Joel C Graff
A method for instantiating classes using Reflection.
1 Mar 2022 by W. García
A class module developed to evaluate mathematical expressions given as VBA strings
2 Mar 2017 by Dracula
VBA Macros Provide Yahoo Stock Quote Downloads in Excel 2007
3 Jun 2013 by StewBob
This article gives a method for using Excel VBA to convert discrete data points into a histogram.
10 Mar 2014 by EiadXP
This is a very fast way to access string (or other) data with minimum memory consumption.
7 Mar 2012 by Yiannis Spyridakis
This articles describes the implementation of functors (of sorts) for VBA using C++ ATL.
15 Jan 2013 by Marco Sorich
Some guidelines for developing better MS Access solutions.
16 Jul 2010 by E.F. Nijboer
Source code for saving mail items to separate files and keeping folder structure
2 Mar 2011 by Won Dong
To utilize cloud service as an anonymous desktop environment in Amazon S3 and EC2 Windows instances
3 Sep 2013 by 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 by Alexandros Pappas
This article proposes a way to do book-keeping for home use.
24 Feb 2019 by 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)