You can check the template for how INDEX formula enables the search function within the worksheet using a textbox. Download template with full access (Password: jafarpp.in)
BMI Calculator
Calculate Your Body Mass Index. Body mass index (BMI) is a measure of body fat based on height and weight that applies to adult men and women. Enter your weight and height using standard or metric measures.
Suicide of An Excel File!
This is not a story, an amazing VBA code to protect your highly confidential excel file from theft/miss use. If you have developed a workbook which you want to self-expire by a certain date, such as a demonstration model or containing information or usefulness that will be outdated, you can program a workbook to delete […]
Auto Save Excel File After Cell Value Change
A macro-enabled excel file can save automatically when changing any cell value. See the below given VBA code for autosave : 1. Right-click the sheet tab that you want to autosave the workbook after entering new data, and then choose View Code from the context menu, in the opened Microsoft Visual Basic for Applications window, copy and […]