Click here to Skip to main content

Submit your article

VBA

VBA

Great Reads

Exploring Computational Number Theory (Part 1)

by William Hey

Classical number theories

Excel, Jira, Rest API end to end example

by bradyguy

An end to end view of how to integrate Jira REST API's with Excel.

A Tree-View Control Using an MS Access Table and Form

by RB Starkey

How to create a tree-view control using an Access table and form.

Semi-Prime Ordered Sequences (Part 2)

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

Office Programming Helper Indent VB Code

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

Float Point Numbers as Approximates & Using Errors

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

PHP, VBA and SQL Useful Scripts

by Mirzakhmet Syzdykov

Development process in few steps with the help of scripting software

All Articles

VBA

Microsoft Excel: How to Comment Cells

21 May 2015 by Alexey Shtykov

Convert column numbers to range letters and add comments

VBA: Excel / Word to PDF Encrypted / Password Protected

19 May 2015 by algor-AG

VBA: Excel / Word programmatically save document as PDF encrypted / password protected.

Export MS-Outlook Messages as EML or MS-Word Files With Attachments as Separate Files

16 Sep 2016 by axuno

Take this ready-to-use VBA module for MS-Outlook, that lets you export all mail messages selected in the current Outlook email browser to the file system.

Spread Sheet Integrated Progress Bar

19 Apr 2015 by Bernster

How to use Excel conditional formatting features to simulate a progress bar in an Excel worksheet

A quick & simple VBA FIFO Queue Implementation

4 Apr 2012 by BorysT

This is an alternative for "A quick & simple VBA FIFO Queue Implementation"

Gathering Bloomberg Data with Synchronous VBA Calls to the API

4 Oct 2012 by Chris Spicer

This article illustrates the simplest possible way of retrieving data from Bloomberg via the VBA API.

Automate Chrome / Edge using VBA

3 Nov 2021 by ChrisK23

A method to automate Chrome (based) browsers using VBA

Method to Change Source of a Form’s Subform Source to a Query or Table in Microsoft Access

12 Sep 2018 by Clifford Nelson

Method to change source of a Form’s Subform source to a Query or Table in Microsoft Access

Selecting and Importing Excel File and Sheet for import into Access

7 Sep 2018 by Clifford Nelson

This is a tip that has the code for selecting an Excel file and sheet for import into Microsoft Access. This includes the code required to browse for a file, and populate a ListBox with the sheets of the Excel Workbook, and the code to import an Excel spreadsheet.

Converting Column Numbers to Range Headers and Vice Versa

2 Sep 2020 by Darren G441

Two functions to help manipulate Excel sheets with VBA by converting Column Header letters to 1 based numbers and back

A Basic Rules Engine in Excel VBA

1 Oct 2015 by DP17000

A rudimentary expert system in VBA/ Excel 2013

Insert Outlook Contact Birthdays in Calendar

15 Nov 2010 by Edzko

This macro can be inserted in Outlook 2000 to search all your contacts for birthday information. If the birthday does not appear in the calendar, then insert it. The macro will dump a small text file "c:\Outlook.log" that lists the activity.

Writing Excel UDFs and Macros in Python with ExcelPython

22 Aug 2014 by Eric Reynolds

Learn how to easily substitute VBA with Python as Excel's scripting language with a library called ExcelPython

MIME / B64 Outlook attachment joiner

18 Sep 2010 by ErnestoNet

How to join the parts of a file across several mails in MIME / Base 64 format in outlook

Custom disk clean up using WSH VBScript

1 Aug 2014 by Gautham Prabhu K

Perform custom disk clean up when hard disk free space goes low

Copy Rows Within Excel Sheets via VBA

3 Oct 2014 by Gautham Prabhu K

Copying entire row within Excel sheet using VBA in Microsoft Office 2010 and higher

A Simple List Class for VBA Projects

16 Jan 2016 by Glenn Lloyd

This is an alternative for "A Simple List Class for VBA Projects"

Rounding Values Up, Down, By 4/5, Or To Significant Figures

9 Oct 2015 by Gustav Brock

Generic VBA functions for all the normal rounding methods - of any value that VBA can handle.

Merge Many Excel Files into one VBS

14 Jul 2020 by Igor Krupitsky

This VBS will merge Many Excel files into one

Merge Excel Files into One Using VB Script

24 Jun 2020 by Igor Krupitsky

How to merge multiple Excel files into one with the help of VB script

Merge many Excel Worksheets into one using VBS

4 May 2020 by Igor Krupitsky

This VBS will merge Many Excel Worksheets into one.

Outlook Attachments Counter, Don't Send Mails Without Attachments Anymore

27 Feb 2022 by Joan M

When you forget to attach an invoice and your customer doesn't alert you... well, you start thinking about methods to prevent it from happening again.

Non-FormControl Checkbox in Excel with VBA

26 Jul 2012 by Kudredin

How to use a normal Excel cell within a worksheet as a checkbox

Automatically Readloud Sender and Email Subject in OUTLOOK

17 Jan 2015 by Liju Sankar

Read Loud Email Sender and Subject as soon as you received an email in OUTLOOK

Excel Search Tool (Macro)

12 Jun 2017 by LukeCodes

This is a simple macro script to search and retrieve individual cells in an Excel document.

Copy Data Between Excel Sheets using VBA

17 May 2017 by Maciej Los

This is an alternative for "Copy Rows Within Excel Sheets via VBA"

Make Outlook E-mail and Appointment Alerts 'top most'

16 Dec 2015 by maxitone

Use this if you're working in a fullscreen RDP session - for example - to see new e-mail or appointment alerts

Timestamp Converter for Excel (VBA)

9 Sep 2022 by Member 10211581

Converts a column of timestamps with a format "hh:mm:ss.000" (or similar) to a column of cumlative decimal values of time in units of sec, min, hrs or days.

Macro to Change the Color of all Equations in a Word Document

6 Apr 2019 by Member 12994860

Change the Font Color of all Equations in a Word Document

A Simple Excel VBA Development Workflow

29 Jun 2020 by Member 14874449

Walk-through and source code for an Excel VBA development workflow

Help for the Access 2000-2003 developer with 'Out of Memory' issues or problematic codebase

24 Dec 2010 by Mike Baldini

The following code filters the specified database

PHP, VBA and SQL Useful Scripts

20 May 2023 by Mirzakhmet Syzdykov

Development process in few steps with the help of scripting software

Excel Molar Mass Calculator - Molecular Weight

8 Mar 2020 by NewPast

Excel, Pure VBA Macro: Molecular Weight/Molecular Mass Calculator

Import Export Wizard

16 Mar 2012 by Sachin Chandanshive

Read / Write data from CSV to Excel

Addin With Useful Macros & Easily Accessible From Custom Ribbon Tab

13 Aug 2012 by Sachin Chandanshive

Addin Containg Useful Macros & Easily Accessible From Ribbon Menu

Using Web Configs Key Value pair in classical Asp pages

19 Sep 2014 by Shekhar Pankaj

Using Web Configs Key Value pair in classical Asp pages

Excel Google Maps Add-In

8 Oct 2015 by Sotirios Diamantis

You have latitude and longitude coordinates in Excel and you want to display them in Google maps; this simple Excel add-in will let you do just that.

A quick & simple VBA HashTable Implementation

8 Jul 2010 by Stefan Huy

VBA Hashtable Visual Basic Hash

A quick & simple VBA FIFO Queue Implementation

8 Jul 2010 by Stefan Huy

VBA Hashtable Visual Basic Queue FIFO

A Simple List Class for VBA Projects

16 Dec 2013 by Stefan Huy

For those who badly miss a .NET like List in VBA

A quick & simple VBA LIFO Stack Implementation with PUSH und POP

8 Jul 2010 by Stefan Huy

VBA Hashtable Visual Basic Stack LIFO

Automatically Format Foreign Words in a Word Document

24 Jun 2015 by Steven de Jong

Many professionals have to use foreign-language terms in their documents (e.g. English terminology); this macro automatically formats these terms.

VBA macro user interaction with SelectionBox

4 Feb 2015 by uildriks

Introduces the SelectionBox for simple user interaction in Office macros, akin to the VBA InputBox

Encrypting Applications web.config Using .NET Framework Utility

21 Oct 2015 by Umarfarukh7

This tip is about encrypting web.cofig file using aspnet_regiis utility of .NET Framework.

How to Create Speedometer Gauge and Thermometer as a Chart in MS Access

26 Jun 2021 by VBA55

Display data in chart as Speedometer or Thermometer graphic

Use VBA to Make a Picture Transparent in Microsoft Office

8 Nov 2015 by veen_rp

Why can't you set transparency to a picture in an MSOffice application? Well, you can use a clumsy work-around to create a shape and paste your picture from the clipboard. Here's the code to automate it from VBA.

Launching a VB.NET Class Library from an MS-Office Excel Ribbon

9 Nov 2015 by veen_rp

A simple, step by step tutorial to set up an MS-Office Excel Ribbon, launch your own .NET applications from Excel and interact with the spreadsheet values.

Non-Recursive JSON Parser for VBA

27 Jun 2012 by Vinolarium

Sample code for parsing JSON with deep-nested schemas in VBA.

Parsing CSV Files Directly from VBA

8 Mar 2021 by W. García

VBA solution for CSV parsing problem

Querying CSV in a Like SQL Way from VBA [Microsoft Excel and Access]

17 Mar 2021 by W. García

Fully VBA “Power Query” alternative for work with CSV files

A Very Basic Singely Linked List for VBA

16 Mar 2019 by WhiskeyBeforeWater

A nodular Singely Linked List for VBA with some basic functions