How often do we get dates in spreadsheets supplied to us as 12.26.2016, or 26/12/2016 (UK format), only to be told the date is invalid or there's no month 26? This article explores fixing dates with VBA, using TRIM, LEFT, RIGHT and MID functions.
The article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window".
The xlsm in this exercise can be downloaded here.
Not Our Problem!
The...
Read more »
In this article, there are 4 easy tips for you to change the color of comment balloons or texts in your Word document.
By and large, the color of comment balloons in document is randomly assigned by Word according to the editing author. Similarly, the comment text color is by default set in black. Nevertheless, we still can apply some tricks to change the default color.
Tip 1: Apply Custom Color for Comment Balloons
It’s a popular knowledge that Word distributes color to comment balloons...
Read more »
In this article, we want to present you 2 quick and efficient ways to get the difference between 2 specific dates or times via Word macros.
To calculate the days or time left between 2 concrete dates or times is of no difficulty. You can either do the math by yourself or get a date or time duration calculator. And here we want to demonstrate you the 2 macro ways which enable you to get the date or time difference in Word. Following are the detailed steps:
Get the Date Difference
First...
Read more »
