VBA Code to Add Items in ListBox Control in Userform
VBA TRICKS

VBA Code to Add Items in ListBox Control in Userform

Using ListBox in Userform is very common. You can use ListBox.AddItem function to add items in the listbox.; however, it is little difficult to add items in Listbox when the number of columns are more than one. Here is a sample VBA code to help you ‘Event handler to add …

Read More
VBA TRICKS

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: After Sort:     If you are looking for a VBA code that can sort …

Read More
VBA TRICKS

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 ensures if there is already a filter applied then the same is removed first Step …

Read More
FREE VBA UTILITIES

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 ExcelSirJi team. With this Excel Consolidator tool, you will be able to consolidate data from …

Read More
FREE VBA UTILITIES
3

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 Modified Size (MB) Type  You just need to browse the folder where your files are …

Read More
FREE VBA UTILITIES
3

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, enter Base folder path where you want to create folders and the name of the …

Read More
VBA TRICKS
1

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 on Excel sheet. Note that if there are sub-folders available in the folder then this …

Read More
VBA TRICKS
1

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 …

Read More

error

Like the Article? Please spread the word :)

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn