In today’s world, the data sets we have is huge and we can have so many criteria to be followed on the data For Example: Sum Average etc. Let us say we have N products in our superstore and we have to find the total number of sales made in […]
Excel Sheet Protection Check
December 21, 2024
Detect Sheet Protection Whenever working with a worksheet ever wondered why some menu buttons are not working or ribbon icons are greyed out and no functionality doesn’t work, this happened to me and because of a silly mistake. I can’t say how many times this has happened to me while […]
LET( ) Function in Excel
December 21, 2024
What is a LET function in Excel? The LET function in excel is used to assign the name of the calculations of the result. This allows storing of intermediate results of some calculations, values, name of some functions defined inside a formula. These name only apply within the scope of […]
VBA Message Box Set No as Default Button
December 21, 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
December 21, 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
December 21, 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 […]
Add Excel VBA Drop Down Data Validation List
December 21, 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 […]
Excel VBA Delete Folder if Exists
December 21, 2024
Delete Folder using Excel VBA Macro This Excel VBA code will get folder path as input, check if it exists. Then it will delete if it exists. Important Note: Do not test this code with any important folder in your computer. You will end up in deleting important files in […]
VBA Msgbox with Yes No Cancel Options
December 21, 2024
User Input Msgbox with Yes No Cancel Some time the VBA code has to get approval from user with Yes/No/Cancel optop. Here is the simple code snippet that get the Yes, No, Cancel options in a popup window. Example scenario for this would be like if there is any file […]
VBA Copy File to Folder
December 21, 2024
Excel VBA Macro to Copy File This page explains about 2 options to do file copy using Vba. CopyFile option from FileSystemObject VBA.Filecopy The first one has more options like: Adding wild cards with source file & option to overwrite a file if already exists. Vba built in Filecopy function […]