Creating Effective Forms with Excel – The Simple Data Form (Part 1 of 3)
Have you ever gotten an online form from a company or government organization and received a PDF that you had to print out and fill out by hand (and you’ve probably even seen one that looks like a scan of a scan of a poorly built form on an old IBM typewriter)? What’s the point? [...]
Read More About - Creating Effective Forms with Excel – The Simple Data Form (Part 1 of 3) »
VB HTML Maker Update
When I first starting really getting into VBA, it was pretty invaluable to me to be able to read over my code. And over and over and over my code again. And again. As well as others code. This really helped me learn the syntax and flow. An add-in which was great, which I can’t [...]
Create a Table of Contents in Excel
There has always been a need for a good Table of Contents in Excel. While Word features this natively with its built-in Styles, unfortunately, Excel lacks this functionality due to a host of reasons, which are quite valid. However, we can create a workaround by incorporating some VBA. The following code is an updated version [...]
Create Outlook email and appointments from Excel with VBA
The power of Microsoft Office is quite undeniable. The premier application of the suite is Excel. The love/hate relationship we have all had with it endures. Often times you may find the need to utilize multiple Office applications from within one another. An extremely common request is to create emails and appointments in Outlook, all [...]
Read More About - Create Outlook email and appointments from Excel with VBA »
