Steps to convert Python to Exe using PyInstaller. These simple steps will convert a Python source code .Py file to executable file that can be distributed to other computers.
VBA Message Box Set No as Default Button
September 03, 2021
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
September 03, 2021
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
September 03, 2021
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
September 03, 2021
[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
September 03, 2021
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
September 03, 2021
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 […]
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
September 03, 2021
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
September 03, 2021
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 […]
