Add a simple search box to a Microsoft Access form
Posted 12th November 2020
6 comments
A step-by-step guide to adding a simple search box to a Microsoft Access form.
Duplicate Excel cells multiple times
Posted 13th April 2016
No comments
Use this Visual Basic script in Microsoft Excel to duplicate cells a specified number of times.
RGB to HEX in Excel
Posted 24th March 2016
17 comments
Use Microsoft Excel to convert Red-Green-Blue (RGB) values into hexadecimal colour codes and display the relevant colour graphically beside each output.
Rearrange Excel columns via Visual Basic
Posted 16th March 2016
22 comments
A simple VBA script for rearranging the order of columns in an Excel spreadsheet.
VBA: Test if a font is installed when a Word file opens
Posted 3rd December 2015
No comments
If a required font is missing, this script will alert a user that the font needs to be installed on their local computer before a Microsoft Word file will display properly.
VBA: Convert text to columns for all worksheets in Excel
Posted 26th November 2015
7 comments
A small Visual Basic for Applications (VBA) script which will loop through all sheets in an Excel workbook and convert text to columns.
VBA: Automatically format specific text in Microsoft Word
Posted 14th October 2015
2 comments
Use this simple Visual Basic for Applications (VBA) script to reformat any text string within Microsoft Word.
VBA: Delete all Excel columns except those named
Posted 16th September 2015
2 comments
Use this simple VBA script to delete all columns in a worksheet except those that are specifically named.
VBA: Create a list of all external data references in Excel
Posted 15th September 2015
4 comments
Use this simple Visual Basic for Applications script to list every external link within an Excel workbook.
VBA: List all formulae in an Excel workbook
Posted 2nd July 2015
2 comments
Described is a convenient method for using VBA scripts to extract every formula from a Microsoft Excel workbook and create a list of them in a separate sheet for later reference or backup.