BLOG
EXCEL VBA TRICKS

VBA Code to Browse a Folder

Quite often a VBA developer requires code to browse a folder. This is mainly for saving the output file or reading the input file(s). Below is the VBA code that can be used to browse a file folder. Public Sub PickAFolder() ‘Microsoft Office XX.X Object Library is required to run …

Read More
EXCEL VBA TRICKS

VBA Code to Browse an Outlook Folder

Outlook is most commonly used emailing application used in the world. Many people spend their entire day on Outlook application to read and response to emails. To automate certain rule based tasks in Outlook, we can take help of VBA. Below is one of the commonly used VBA code to …

Read More
EXCEL VBA TRICKS

VBA Code to Count Color Cells with Conditional Formatting

Have you ever got into situation in office where you need to count the cells with specific color in conditional formatted Excel sheet? If yes then you can use following code which counts the number of cells with specific color (here it is yellow) and put the count in cell …

Read More
EXCEL 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
EXCEL VBA TRICKS

VBA Code to Count Color Cells in Excel Sheet

Have you ever got into situation in office where you need to count the cells in Excel sheet with specific color? If yes then you can use following code which counts the number of cells with specific color (here it is yellow) and put the count in cell It is …

Read More