BLOG
VBA TRICKS

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 Worksheets.Add After:=Worksheets(Worksheets.Count)   If you want to add the new worksheet at the beginning of …

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 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 Shapes, Charts, Pictures, Objects and Equations from the sheet ‘Following function deletes all the Shapes, …

Read More
VBA TRICKS
3

VBA Code to Convert Excel Range into HTML Table

As a VBA developer you may frequently come cross with a requirement of sending an email through Outlook along with an HTML table inside email body. Adding an HTML table in email body is very simple task if you do manually, just copy the range in Excel and paste it …

Read More
FREE VBA UTILITIES

Custom Calendar Control for MS Access

MS Access by default provides inbuilt functionality to pick dates using calendar control; however it lacks few basic functionalities which makes selecting a date bit difficult. For example, if you want to select a date from year 2015 then you need to navigate multiple times to select correct date since …

Read More
VBA TRICKS

How to Add Outlook Reference in Excel VBA

To automate Outlook based tasks from Excel you need to add Outlook Object Library (Microsoft Outlook XX.X Object Library) in Excel References. You can follow below steps to add Outlook reference in Excel VBA: 1. From the Menu Bar, click on Tools > References… 2. Select ‘Microsoft Outlook XX.X Object …

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

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn