VBA Multilevel Dependent Drop-Down in a UserForm
A multilevel dependent drop-down in a VBA UserForm lets your users pick a Category, then see only the Sub Categories that belong to it, then only the matching Items, and
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 User Form Validation for Mobile Number Input
VBA user form validation for mobile number input stops bad data before it ever reaches your worksheet. In this tutorial you build a small Excel UserForm with one text box
VBA Filter Data with Multiple Values and Copy to Another Sheet
With a short macro you can filter data with multiple values in VBA and copy the result to another sheet in one click. Instead of ticking names in the filter
Count Sub-strings in an Excel Cell with a User Defined Function
Need to count sub-strings in an Excel cell? It happens all the time: a cell holds comma-separated ticket numbers, a semicolon-separated list of email IDs or a string of codes
Split Data into Separate Workbooks in Excel (VBA Macro)
When one long sheet holds the data for many people, you often have to split data into separate workbooks, one file per supervisor, region or customer, so that each person
Personal Macro in Excel: Quick Data Formatting with Ctrl+M
A personal macro in Excel is a macro saved in your hidden Personal Macro Workbook (PERSONAL.XLSB), so it is ready in every workbook you open on that computer. In this
Send Email with Snapshot in Excel VBA: Range in Outlook Body
With a short Excel VBA macro you can send an email with a snapshot of your worksheet: the text, charts, pictures and tables in a range land in the body
Text Join Formula for All Excel Versions: TEXTJOIN UDF in VBA
This text join formula for all Excel versions gives you TEXTJOIN-style results even if your Excel does not have the TEXTJOIN function. TEXTJOIN joins a whole range of cells into
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: Add, Update and Delete with VBA
A data entry form in Excel lets users add, update and delete records through a clean pop-up window instead of typing straight into the sheet. In this tutorial you build