Convert Number Format or Currency Format This is something I learned today. One of my friends called me for a help. He has Excel sheet with numbers like this. 33,32,100 and 31,10,100 – Typical Indian Currency format If we select 2 or more cells with numbers in it, Excel displays […]
World’s Simplest Key logger using VB6
Learn how a Key Logger is coded using VB6 with just simple code & then how it can be used to record the key strokes by running at the background
Text To Speech Application – VB6 Voice Code
Get VB6 Text to Speech code using Win32 Speech API (SAPI or TTS) & develope VB6 application with voice options enabled.
Enable Image Thumbnail Preview to Display Picture in Folder – Windows System?
Learn how to enable Image preview to display pictures in the Folders for Windows Operating System. Enable this option in Folder options to view the thumbnail image preview for pictures in the Windows Folder.
How To Find Smallest & Largest value in a Range in Excel?
Use this function to find the largest or smallest values from list of values from a worksheet range. The same function can be used in a Excel VBA Macro coding also.
How to get Age from Date of Birth in Excel? – Formula & VBA
How to Calculate Age from Date of birth in Excel using Excel formula & VBA Macro? This page has Formula & macro mentioned to instantly get the age in Years, Months & Days
Excel Compare Two Columns for Duplicates – Highlight Differences
Excel compare two columns & highlight the duplicates or unique values. This is a simple built in option available in conditional formatting to change the background of duplicate or unique values in the selected range of values.
How to Split Date & Time – In Excel Worksheet?
Worksheet Date & Time – How to Split it? In worksheet type this function to get Time enter the formula ‘=Now()’ . It will return the default value as today’s date & time in the cell. Something like this. ‘5/7/2018 13:53’ You can see that there is a Date part […]
Calculate Excel Date Difference in Days – Get Simple Formula
How To Calculate Excel Date Difference? To get the difference between 2 days & get the number of days between these dates, you can use one of these methods. Here you will find how to find Excel Date difference in days: Worksheet – Formula to calcualte Date difference Excel VBA […]
Excel Add WorkDays To Date – Excluding Weekends & Holidays
Excel – Add Days to Date – Excluding weekends & holidays. This formula & VBA function will add workdays to a start date & give the end date to plan for your project or task.