Custom Toggle Button in Excel and Power BI
In this article, we have created a custom Toggle Button in Excel and Power BI to toggle the Chart and Table on click of this toggle button. This trick could be
Tag: VBA
Send bulk emails using VBA and Outlook
In this article, we have create an automation to Send bulk emails using VBA and Outlook on one click. This automation will send the emails using Microsoft Outlook. Visit our
Time Picker and Date Time Picker Control in VBA
In this article, we have created Time Picker and Date Time Picker control in VBA. We have used User form, Spin buttons, Text boxes and Command buttons to create these
Universal Searchable Drop-down List in Excel
In this article, we have created a universal searchable drop-down list in Excel. It is useful when you have multiple items in your data validation drop-down list. You can use
Data Segregation Tool in Excel VBA
In this article, we have created a Data Segregation Tool using Excel VBA. It is ready to use Tool to segregate your data into multiple sheets for Multiple files. Data
User level security in Excel Workbook for different worksheets
In this article, we have created User level security in Excel workbook. If you have multiple worksheets in your excel file and you want to protect/hide the data according to
Inventory Management form in Excel
Inventory Management system is very useful for any business. We have created this ready to use template for Sales/Purchase and Inventory Management Form in Excel VBA. [purchase_link id="62207" text="Purchase" style="button"
Automated Bulk Emails Form in Excel VBA
In this article, we have created an Automated Bulk Email User form to send the bulk emails using Microsoft Outlook. We have taken two different type of emails – Customer
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
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