BLOG
VBA TRICKS
2

VBA Code to Hide Menu Ribbon in MS Access

In MS Access, there are multiple ways to protect your code or tool from un-authorized access and edits. Some developers prefers to hide MS Access ribbons from the users to prevent changes by users. Here is one of the way you can hide MS Access Ribbons, Lock the Navigation Pane …

Read More
VBA TRICKS

VBA Code to Export Access Recordset to Excel

Creating a VBA tool in MS Access is always better as compare to MS Excel. MS Access provides better user interface and ability to handle multiple users. Still people prefer to pull and see the reports in MS Excel. Below VBA code helps you to export MS Access data into …

Read More
EXCEL TRICKS

How to Create dropdown List in Excel

Excel is an awesome Microsoft utility which most of the professionals are using for their day to day office use as Excel is blood of our daily office lives. Hence it has lots of amazing feature which can ease our data gathering requirements in excel. So here will be talking …

Read More
DATA ANALYSIS TRICKS

Create Dynamic Data Validation List – Offset Function Method

When I started my career in working with excel dashboards, I always used to face most common challenge in “Data Validation” technique where I want a smart data validation to avoid all blank cells and keep adding and deleting the values from drop down dynamically. Here we want to talk …

Read More
VBA TRICKS

VBA Code to Send Outlook Emails

Sending bulk emails is very common activity, there are many office activities which needs a person to send bulk emails to a single or multiple recipients. You also may require to add attachments in the emails. Here is a VBA code that does this task, below VBA code reads recipients, …

Read More
VBA TRICKS
3

VBA Code to Draft Outlook Emails

Have you ever felt the need of an Excel based VBA tool or code which can help you to draft Outlook emails in bulk by reading recipients and other details from Excel? Here is very simple solution to your problem, you can use below VBA code to draft emails in …

Read More
VBA TRICKS

VBA Code to Read Outlook Emails

Reading emails from Outlook and capture them in Excel file is very common activity being performed in office environment. Doing this activity manually every time is quite boring and time consuming. Here is a VBA code that can help you in this, you can use this code to select an …

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

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn