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
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
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

VBA Code to Get Logged in User Name

Sometimes in VBA projects, a programmer is required to control the access on the data or sheets. This can be achieved using two ways: 1. Design a login userform and display it on the open event of the workbook. Based on the credentials, you can access the control on the …

Read More
VBA TRICKS

VBA Code to Browse a File

There are few VBA codes which are commonly used by every developer. One of them is giving an option to user to browse a file. Below is a sample code where I have given a browse button (shape) in an Excel sheet. User can click on this button/shape and select an Excel …

Read More

error

Like the Article? Please spread the word :)

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn