Smart Data Entry form with minimum VBA
In this article, we have a Smart data entry form for candidate information with minimum VBA. We have used Excel formulas, conditional formatting and Form Controls. You can replicate this
Templates
Find pre-designed and customizable Excel templates for various purposes, such as budgeting, project management, HR, and inventory management, in this category. Get step-by-step instructions, video tutorial and a free download for each template. Whether you’re a small business owner, project manager, or student, you’ll find a template that suits your needs. Streamline your work and achieve your goals with ease by exploring this category and taking advantage of our free templates.
Fully Functional To-do List in Excel
In this article, we have created a fully functional To-Do list template in Microsoft Excel. We have used VBA to create this template. You can use this template in your
Daily Activity Tracker in Excel
In this article, we have created a simple Daily Activity Tracker in Excel. You can use this Activity tracker to track your daily activity and you can create a database
PDF to Excel Converter in Excel VBA
In this article, you will learn how to create a PDF to Excel converter using Excel VBA. We have created a Setting worksheet wherein we are taking 2 folders inputs
Fully Functional Dynamic Calendar Control in VBA
Ah, The complexities of automation! The versatile and multifaceted world of Excel VBA offers an array of tools and functionalities to streamline tasks and make life easier. Yet, despite its
Quality Check List in Excel
The template of Quality Check List in Excel has been designed to use for quality team. It can be use for other purposes also. Here we have taken the drop-down as
Automation: Word to PDF Converter
In the previous article you have learnt how to Excel to PDF converter using VBA. In this article you will learn how to convert multiple Word files into PDF file using
Automation: Excel to PDF Converter
In this article you will learn how to convert multiple Excel files into PDF file using VBA. This is quite useful and easy macro. We have used File System Object
Send Email with Snapshot in Excel VBA
In this article you will learn how to send an Outlook Email with mail body snapshot like Excel tables, Charts or images by using VBA. We will use "Mail Envelope" method
Dynamic Calendar in Excel
The dynamic calendar template is a must-have for keeping track of important dates and appointments. It's easy to change the month and year and the calendar updates automatically. Form Control