VBA Code to Change Sheet Tab Color
Here is another help code for programmers to change the color of Excel sheet tab. I have shown two ways to achieve this: Using standard colors like Green, Blue, Red, White etc. Using RGB (Red,…
VBA Code to Sort Data
Here is a one line code for developer’s reference which can be used to sort data ‘Sort data in ascending order on Column F (Created At) Sheet1.Range(“A1:G” & Sheet1.Cells.SpecialCells(xlCellTypeLastCell).Row).Sort Key1:=Sheet1.Range(“F1”), Order1:=xlAscending, Header:=xlYes, DataOption1:=xlSortNormal Before Sort:…
VBA Code to Filter Data in Excel
Here is an easy reference code which filters data in the sheet. In the code, we have filtered the data in three steps. Step 1: Remove existing filter from the sheet (if any). This code…
VBA Tool to Merge Excel Files from a Folder
From last few months, we have been receiving frequent requests from users for a VBA tool which can consolidate Excel files from a folder. So here we come with one more free VBA tool from...
VBA Code to Change Cell Color
Excel supports more than 16 million colors in a cell; hence you should know how to set the exact color in a cell. To do this, you can use RGB (Red, Green, Blue) function in...
How to get RGB Codes of a Color
Excel supports more than 16 million colors in a cell; hence you should know how to set the exact color in a cell. To do this through VBA, you can use RGB (Red, Green, Blue)…
VBA Code to Convert MM.DD.YYYY Format to DD-MMM-YYYY
In different parts of the world, there are different languages spoken and written. With this, a VBA programmer also faces language related issues while writing a VBA program. Here is a common date related problem…
Impress your Clients by Hiding these Simple Features
While preparing many projects, my clients always want me to make professional, good looking dashboards. So I hide few things like Gridlines, Column & Row headings and Formula Bar. This can give WOW experience to…
Protect Sheets, Share Workbook, Protect Workbook
Creating beautiful and professional dashboards, projects always lead you to success however there are places when you wanted to protect your dashboards, sheets, cells to prevent users to make unnecessary editing because it can change…
Excel VBA Tool to Get File Properties
Here is one more interesting VBA tool from ExcelSirJi team. File Properties Tool is an Excel VBA tool which gets the following properties of the file. File Name Date Created Date Last Accessed Date Last...
TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?
You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use…
Excel VBA Tool to Create Folders
In VBA, you can use MkDir function to create folders in your system or shared drive. To make your work simple, we bring a free Excel VBA tool to create folders. To use this tool,…
VBA Code to Re-link MS Access Link Tables
In MS Access, the best way to create a multiuser tool is to divide your solution. One part acts as interface and other one acts as database. You can have multiple copies of the interface distributed to users which are connected to central MS Access database saved at common shared drive. To connect the interface to database, you can use link table feature (Access>External Data>Import & Link) available in MS Access. Below is a commonly required VBA code which helps the developers to re-link MS Access linked tables when the database is renamed or moved to other location
VBA Code to List Files in Folder
To work on multiples files through VBA programming, you need to have VBA code which can list files in a folder. Here is a simple code for you, this function list files in a folder...
VBA Code to Check if File Exist in Folder
To ensure that your VBA project works smoothly without any error, you need to put lot of error handlers and validations. Here is one of them, below code can be used to check if the given path is valid or not. You just need to provide the path of the file to the function and it will check if the file exist at the location. If it returns True that means the file is available at the path, if it returns False that means it is invalid path or the file does not exist at the location.
VBA Code to Add New Sheet at Beginning or End of Excel File
In VBA, it is sometime important to add a worksheet at the right place in the Excel. Here is a simple an effective code that adds a new worksheet at the end of Excel file…
VBA Code to Get Logged in User Name
This Excel VBA Code helps to Get User Name. Here is an example environ(username) or Application.username.This macro gets the username from active directory.
VBA Code to Delete All Shapes from Excel Sheet
Here is a VBA code which deletes all the shapes from an Excel sheet. Code is simple but you have to be bit careful while using this code as it deletes all the Shapes, Smart…