Accept Valid Dates Only From User in Excel VBA

In my recent task, I was required to accept input from the user. One input value was the date of birth and it, of course, must be a date. What I was d...

Identifying duplicate time frames

If you want to find out the duplicate row having multiple entries for same person & you want to find out duplicate entries, then you should not mi...

Insert Date Time Stamp with VBA

Inserting date time in Excel using VBA is as simple as writing a formula in a Cell. The VBA timestamp code is: Range(“A1”).value = Format(Now,...

How we can format date through VBA?

In this article we will learn how to format the date through VBA. Let’s take an example to understand how and where we can format the cell in sho...

Sort the data by birthday using VBA in Microsoft Excel

In this article, we will create a macro for sorting data in the sheet by birthday and we will not consider year while sorting the data. Raw data cons...

Enter the Weekdays Mon – Fri in a Worksheet using VBA in Microsoft Excel

In this article, we will create a macro to extract the weekdays between two dates. In this example, we have to specify start date and end date before...

List and add days of months in a set period using VBA in Microsoft Excel

In this article, we will create a macro to list months between the defined period and also number of days in that particular month. It will also dis...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.