Smart Attendance Manager in Excel VBA
In this article, we have developed a Smart Attendance Manager in Excel Using VBA using VBA User forms. You can use this form to manage the attendance of your team or
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.
Calculate Ratio in Excel
In this article, we have explained how to Calculate Ratio between two number in Excel. We have used the Excel formula as well as the User defined function in VBA to
Shell Function in VBA
Shell Function in VBA can run executable program and returns a Variant (Double) representing the program's task ID if successful otherwise, it returns zero. Syntax Shell(pathname, [ windowstyle ]) pathname:
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
RandBetweenText Formula in Excel
In this article, we have created a user defined function RandBetweenText Formula in Excel. This function returns random text from the selected range. You can use this function to distribute
VBA Application with MS Access Database
In this article, we have create a VBA application with MS Access database using ADODB connectivity. We have created the Rent Management System. We have used VBA user form with
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
Delete all blank worksheet using Personal Macro
In this article, we have create the a Personal Macro to delete all blank worksheet from active workbook. You can use this for the workbook wherein you have multiple worksheet
Excel VBA based Application with SQL database
In this article, we have created a Excel VBA based Application with SQL database. We have used ADODB connection to connect the database. In this application we have created Insert,
Bulk File Creator in Excel VBA
In this article, we have created an automation to create the bulk files for Excel, Word and PDF. Here we have used a school mark sheet template. This is a