VBA

Learn how to automate tasks and create custom functions using VBA (Visual Basic for Applications) in this category. Our tutorials cover basic to advanced VBA programming concepts, including creating user-defined functions and interacting with other Office applications. Each tutorial includes a free practice file and tutorial videos to help you learn easily. Increase your productivity in Excel by automating repetitive tasks with VBA macros and functions. Start exploring this category now and take your Excel skills to the next level.

Download attachments form multiple emails

VBA

Download Attachments from Multiple Emails Automatically using VBA

June 21, 2023February 18, 2025 PKComments Off

Automation has become an integral part of our everyday lives, especially in the realm of business. Among many automation tools, Visual Basic for Applications (VBA) stands out for its utility

VBA

Chat GPT in Excel VBA: Create the Data Entry form with AI

June 17, 2023October 7, 2024 PKComments Off

Creating a data entry form using Excel VBA and Chat GPT has never been easier. The combination of these two robust tools can aid in enhancing productivity and efficiency. This

VBA Templates

Fully Automated Bulk WhatsApp Sender in Excel

November 7, 2022March 29, 2024 PKComments Off

Do you work with WhatsApp regularly and want to send bulk WhatsApp messages quickly and easily? Then You will love to learn about our Fully Automated Bulk WhatsApp Sender in

VBA

Make same size of selected shapes/Charts/Pictures using single click

August 16, 2022April 9, 2024 PKComments Off

In this article, we have created a macro to make the same size of the selected shapes, charts, or pictures. It will change the size accordingly to first object in

VBA

Automatic Data Transfer Excel to PowerPoint

July 27, 2022February 21, 2025 PKComments Off

In this article, we have created an Automation to transfer the data from Excel to PowerPoint. You can click on Create PPT button after filling the data in to different

Templates VBA

Invoice Management System V1.0

July 5, 2022February 20, 2025 PKComments Off

In this article, we have created Invoice Management System in Excel. In this template, we have given multiple features as given below - Invoice Management System V1.0 Below are the

Templates VBA

Automated Multiple Emails with Multiple Attachments and “From” option

May 30, 2022February 25, 2025 PKComments Off

In this article, we have created an Automated Bulk Emailer with Multiple Attachments and the "From" option. You can choose the Send or display option buttons. We have given a

VBA

COUNTIF by cells background color in Excel

May 10, 2022August 12, 2024 PKComments Off

COUNTIF is an extremely useful function in Microsoft Excel. We use this function to get the count based on some conditions. Here in this article, we have created a user-defined

Templates VBA

Leave Management System in Excel

April 19, 2022February 18, 2025 PKComments Off

Leave Management System is the enhanced version of the Annual Leave tracker. In this version, we have added a VBA user form to mark the leave for multiple dates in

VBA Templates

Excel to PDF Converter for Selected Worksheets

February 14, 2022February 24, 2025 PKComments Off

Excel to PDF Converter for Selected worksheets is an extremely useful tool to quickly convert Excel to PDF for Active workbook sheets. You can select the sheets in the box