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
January 10, 2025
[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
January 10, 2025
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
January 10, 2025
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 […]
[JS] How to remove particular element in JavaScript Array?
January 10, 2025
JavaScript to Remove Element in Array JavaScript arrays are variables that can store ordered collection of values in them which can be of different datatypes, with each having a numeric position known as indexes. We can add and remove array elements in several ways. So, how do we remove a […]
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
January 10, 2025
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
January 10, 2025
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 […]
[JavaScript] Code To Validate Email Address – in HTML Form
January 10, 2025
HTML Form – Email Validation with JavaScript Email validation is very important in HTML forms. Here we have discussed how to validate email addresses using JavaScript. Parts of an email address An email address is a unique identifier of an email account bound to a domain server. An email address […]
[VBA] How to Convert Word Document to PDF?
January 10, 2025
This page explains how to save a word document to PDF using: VBA Code PDF Converter Manually Save Word as PDF Both the methods are simple & straight forward. Lets start with the automation code first. 1.VBA Code to Convert Word to PDF Word VBA has a direct function to […]