User Defined Function for Sub-strings count from Excel Cell
We often need the count of sub-strings from out text available in Excel. For example we have comma separated ticket number in a cell and we have to count how
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.
VBA: Split Data into Separate Workbooks
In this article you will learn how we can split our data into multiple workbooks. Every workbook will be saved in the given folder path. This macro can be used
Quick Data Formatting by Personal Macro
In this article you will learn how to create a Personal Macro in MS Excel. I have created this personal macro to format the data Quick Data Formatting. Any macros
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
Text Join Formula for all Excel Versions
TEXTJOIN Function was introduced with the release of Excel 2016. This is very helpful function to join the multiple Text Join Formula for all Excel Versions into one. The best
VLOOKUP by cell background color
VLOOKUP is a popular function in Microsoft Excel. It helps users to find and retrieve specific data from a large table or range of data. However, there is a limitation
Data Entry Form in Excel
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