August 21, 2015
Excel Forms – Insert, Update and Delete
Carrying on with the Excel form I created in an earlier post, I’m adding code to allow us to insert
Read MoreAugust 21, 2015
Carrying on with the Excel form I created in an earlier post, I’m adding code to allow us to insert
Read MoreJuly 9, 2015
When creating Excel userforms it seems like a good idea to check the data going into the form before adding
Read MoreJuly 9, 2015
In my previous post about Excel forms the date picker I used was a 32 bit ActiveX control. If mentioning
Read MoreJuly 2, 2015
Excel forms, or Userforms, can be used to collect information from a user, validate it, then enter that data into
Read MoreMay 20, 2015
When you select a cell, or cells, in Excel, the row and column headers change color to indicate what you
Read MoreMarch 30, 2015
You may want some way of pausing or delaying VBA code execution and you can do this with two functions
Read MoreFebruary 19, 2015
A while ago I wrote a routine using the .Find method to find missing numbers in a sequence. So if
Read MoreNovember 19, 2014
What Are Events? An Event occurs when certain actions are performed by the user or VBA. For example when you
Read MoreSeptember 23, 2014
One of our students (hi Leah 🙂 ) sent me a question last week asking how she could change the
Read MoreJune 18, 2014
I recently had a client who has a requirement to protect and unprotect a lot of sheets. This was something
Read MoreJune 18, 2014
You can customize the Ribbon in Excel so that you add your own tabs and icons to run commonly used
Read MoreMay 20, 2014
I wrote a macro a few weeks ago which created a list of files with hyperlinks to those files, but
Read MoreApril 16, 2014
So you have a load of PDF's, or scanned documents, or some nice pictures of your stamp collection*, and you
Read MoreApril 9, 2014
What You Can Do With Macro Enabled Templates This is up to you. Using a template allows you to design
Read MoreApril 9, 2014
If you want Excel to stop asking you if you want to enable macros every time you open a macro
Read MoreApril 1, 2014
I’m sure most of us have experienced frustration at Excel’s refusal to allow us to unhide multiple worksheets. This is
Read MoreApril 1, 2014
When you create a macro in Excel, by default, the macro works only in the workbook that contains it. But
Read MoreFebruary 27, 2014
Barcode Types & Uses There are LOTS of barcode types used for a multitude of things. Various internationally recognised standards
Read MoreFebruary 7, 2014
We get requests now and again asking how to convert numbers to words (or convert currency) e.g. 123.45 becomes One
Read MoreDecember 11, 2013
So you’ve got some code and you want to be able to run it, but opening up the list of
Read MoreNovember 27, 2013
So you’ve found some VBA code on the ‘net that will save you hours and hours of work, but how
Read MoreNovember 27, 2013
The Developer tab in Excel gives you access to features and tools that help you to write and run macros.
Read MoreOctober 14, 2013
Real World Scenario One of my customers (thanks Tony) creates invoices in Excel for his clients and at the end
Read MoreOctober 1, 2013
The Scenario Let’s say that you have a lot of sheets in your workbook and you want to merge all
Read MoreSeptember 11, 2013
The Problem You have a sequence of numbers, and you want to find the numbers that are missing from that
Read MoreAugust 3, 2012
This Excel Factor tip was sent in by Shannon Hommel of the UK. If you’re setting up a template or
Read MoreMay 10, 2012
As I promised last week, today’s tutorial is a dead easy macro that will allow you to extract a list
Read More