VBA Archives

How Chat GPT can help to write Complex Excel Function, VBA code and DAX for Power BI

January 30, 2023January 30, 2023 PKComments Off

Introduction Have you ever tried to write a complex Excel function, VBA code, or DAX using natural language? It can be challenging and time-consuming. If this is your situation, then

Templates VBA

Fully Automated Bulk WhatsApp Sender in Excel

November 7, 2022March 1, 2023 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

Excel Tips and Tricks

Six types of Password Protection in Microsoft Excel

October 31, 2022October 31, 2022 PKComments Off

In this article, we have explained six types of password protection in Excel. You can use these tricks in your Excel reports and VBA Projects file. 1. File Protection to

VBA

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

August 16, 2022August 16, 2022 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, 2022July 27, 2022 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

Automated Multiple Emails with Multiple Attachments and “From” option

May 30, 2022September 18, 2022 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, 2022May 10, 2022 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

Automated Employee Timesheet Template in Excel

April 13, 2022April 13, 2022 PKComments Off

In this article, we have created an automated Employee Timesheet Template in Excel. You can use this template to capture the Employee's Productive hours. We have used several validations and

Templates VBA

Automatic Invoice Creator V1.0

July 18, 2021July 18, 2021 PKComments Off

Automatic Invoice Creator V1.0 is a useful template to create multiple invoices in Excel and PDF format. There are three worksheets in this Automation file. 1-Setting: In this worksheet, you

VBA

5 VBA UserForm Super Tips

March 29, 2021March 29, 2021 PKComments Off

In this article, you will learn 5 super useful VBA User form related tips. You can use these tips in your VBA Application or Automation. Below is the list of