Innovation: Digital Clock in Excel
This time we have developed an innovative and stunning Digital Clock in Excel. We have created this using Excel auto shapes and VBA. Digital Clock in Excel [caption id="attachment_7136" align="aligncenter"
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: Dynamic Chart on User Form
Creating the Chart on a VBA user form is quite interesting. We have created 4 KPI Charts – Battery Chart, Speedometer Chart, Moving Man Chart and Progress Circle Chart on
VBA: Web browser in the User Form
In this article you will learn how to use a web browser in the user form. You can search anything or open a website using the text box VBA: Web
VBA: Multilevel dependent drop-down in User Form
While creating the data entry form in VBA, we need to put several validations. One of them is dependent drop-down. In this article you will learn how to create multilevel
VBA: User form Validation for Mobile Number input
While create the Data Entry form in VBA, We need to put some validation in text boxes and combo boxes. In this article you will how we can put the
VBA: Filter Data with Multiple Values
In this article you will learn how we can use an excel range as a filter criteria and paste the filtered data on another worksheet VBA: Filter Data . For
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: 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