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 also. We have created a progress bar chart also to display the activity completion%. [caption id="attachment_20304" align="aligncenter" width="1070"] Daily Activity Tracker[/caption] Watch the step by step video tutorial: Click here to download practice file-
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 on range E11 and E12 respectively. PDF Files Folder: Wherein all the PDF files are available Excel File Folder: Wherein Excel files will be saved after conversion. [caption id="attachment_15980" align="aligncenter" width="658"] Setting Sheet[/caption] Add the Microsoft Scripting Runtime Reference
This Fully Functional Dynamic Calendar Control in VBA, we have designed to use in VBA project. You can use it for Excel Cells, Textbox, Label and Command Button etc. It is very easy to call this Calendar for your VBA Project. You can call this with two method. Just move this calendar form in your VBA project just drag it using mouse [caption id="attachment_12621" align="aligncenter" width="542"] Move Calendar to your
The template of Quality Check list has been designed to use for quality team.It can be use for other purposes also. Here we have taken the drop-down as Pass/Fail. You can use it as Yes/No, Pending/Completed ect. This template can we used for multiple purposes. It automatically change the text with Icons on the base of conditional formatting. There is no VBA code has been used. Pass/Fail drop down in
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 VBA. This is quite useful and easy macro. We have used File System Object method here. To use the file system object you need to add “Microsoft Scripting Runtime” Reference. To add this Reference go to Visual basic editor >
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 method here. To use the file system object you need to add “Microsoft Scripting Runtime” Reference. To add this Reference go to Visual basic editor > Tools > References > Microsoft Scripting Runtime [caption id="attachment_7149" align="aligncenter" width="459"] Add Reference[/caption] We
This calendar template is fully dynamic. If you will change the month or year in the drop down calendar will be change automatically. To creating the month and year drop down Form Control combo box has been used. It has been created purely in Excel with the help of formulas and conditional formatting. No VBA has been used. [caption id="attachment_2434" align="aligncenter" width="641"] Dynamic Calendar in Excel[/caption] Click to download Dynamic
This template has been designed for consolidating the data from multiple excel file into a single file. This is very time saving template and can make your work very easy. There are two worksheet available in template file, one is "Logs" and second is "Consolidated_Data". Logs worksheet: In this worksheet on Column A you will see the File Names from which you have consolidated the data and on column B
This data entry form has been designed in VBA. You can enter the EMP ID, EMP Name, Gender, Designation and Salary. Since Excel sheet is protected so data can not be changed manually. [caption id="attachment_2413" align="aligncenter" width="546"] Data Entry Form Output[/caption] There are three buttons available in this worksheet. 1.Add New Record By using this button a record can be added on the worksheet. Below given form will be opened
Bow and Arrow Game has been designed in Excel with help of VBA. Few images have been taken form pixabay.com. In this game you have to shoot the apple which is dropping from the tree with the help of 10 arrows. There is a speed drop down available with the Low, Medium and High option. You can the apple dropping and arrow speed by changing this drop down. [caption id="attachment_2401"
