Here is the qualification criteria for MI to get the IPL points table 4th spot for play off match. The net run rate calcualtion for qualification is explained.
VBA Message Box Set No as Default Button
November 28, 2024
How to Set No or Cancel as default Msgbox button? In Msgbox with YesNo or OkCancel buttons, the first button will be set as default button. i.e., once the message box appears if user hit Enter button, Yes or Ok will be activated. Sometimes, this is not desired. In case […]
Hide Unhide Worksheet Tabs in Excel
November 28, 2024
How to hide/Unhide Sheet Tabs in Excel? By default Excel displays the tabs at left hand side bottom. Using this Users can navigate to any worksheet present in the workbook. Note: This article is not able hiding sheets. It is only about sheets tabs. If you chose now to display […]
Remove Drop Down data validation list from Excel & VBA
November 28, 2024
How to Remove DropDown box in Excel & VBA? If you know the cell address that you are going to delete, then it is easy. But there are times, where we might want to delete all the validation lists in a Sheet or a Excel Workbook. Here is the code […]
[VBA] Read Values in Data Validation Drop Down List
November 28, 2024
[VBA] Read Drop Down List Values Add a data validation drop down list as explained in this page. Skip this step if there is already a validation created in the Worksheet & You just want to read the items in the list. We are programming with a Excel sheet. How […]
How to enable JavaScript in my browser? – Chrome,Firefox,IE,Opera,Safari
November 28, 2024
How to enable JavaScript in different browsers? JavaScript should be enabled in the browser if a website has functionalities implemented in js. For example, HTML form validations, Advertisements, Popup menus, Button click events etc., Lets see how to enable JavaScript in these browsers: Chrome IE Firefox Opera Safari If JavaScript […]
Excel VBA List Files in Folder – Dir in Shell
November 28, 2024
List Files in Folder using Excel VBA To get list of files in a directory, just give the folder path as input to this function. It will read the file in the folder one by one. Then display the file names. In this sample code, we will get list of […]
2 Methods To – Remove #N/A Error in Excel – Vlookup
2 Ways to remove #N/A Excel error in VLOOKUP, Worksheet or VBA Macro code. Fix Vlookup #n/a & Excel #n/a common errors formula. Hide n/a Excel Error.
Add Excel VBA Drop Down Data Validation List
November 28, 2024
How to add Data validation drop down list in Excel VBA? Two different methods to create drop down list are explained here – but all are related to validation list. Note: Combo-box control that also display list of values in dropdown is not explained in this page. Adding Drop Down […]
[WordPress] Display HTML Tags inside Pre
November 28, 2024
Display HTML Code in WordPress Post In WordPress posts if we write any HTML codes in Text editor, the code will not be displayed. Instead of code, WordPress, sends the HTML code as it is. The web browser compiles the code to display its output. Hence the code will not […]