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
Tag: VBA
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
Excel Tip : Fill the blanks cells in your data
Many times we have zig-zag data which has to be formatted in proper manner to create some report or dashboard. In this article you will learn how we can Fill
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
Highlight the Specific data point in a Line Chart Dynamically
In this chart we have explained how to Highlight the Specific data point in a Line Chart Dynamically. You can highlight the Minimum, Maximum and Selected data points in a
Info-graphics: Animated Hour Glass Chart in Excel
Animated Hour Glass Chart in Excel has been designed to display the KPI metrics like – Service Level, Quality Score, and Productivity etc. Whenever the value of metric will be
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
Dynamic Project Planner (Gantt Chart) in Excel
Here we have created a beautiful and dynamic Project Planer (Gantt chart) in Excel. We have given a drop-down to change the weekly and daily view. There are 3 type
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
Lock Excel Cell after Updating
One of our client asked us to create a template wherein data can entered only once. As soon as data is entered in the cell, it should be locked for