Create a Dynamic Excel Dashboard with VBA (Dropdown & Highlight Row) in 5 Minutes!
🚀 Create a Dynamic Excel Dashboard with VBA in Less Than 5 Minutes!
In this video, I'll show you how to build an interactive Excel dashboard using VBA to create a dynamic chart controlled by a dropdown menu and automatically highlight the selected row. This technique will help you streamline data visualization and enhance your reports effortlessly!
🔹 What you'll learn in this tutorial:
✅ How to use VBA to update a chart based on a dropdown selection
✅ How to automatically highlight a row based on a selected value
✅ How to create a professional Excel dashboard with minimal effort
✅ Step-by-step VBA code walkthrough
📌 VBA Code Used in the Video:
Copy and paste this VBA code into your worksheet module to make your dashboard dynamic:
vba
Kopiér
Rediger
Private Sub Worksheet_Change(ByVal Target As Range)
Dim ws As Worksheet
Dim searchValue As String
Dim lastRow As Long
Dim rng As Range, cell As Range
Dim foundRow As Long
Set ws = Me
If Not Intersect(Target, ws.Range("B3")) Is Nothing Then
searchValue = ws.Range("B3").Value
lastRow = ws.Cells(ws.Rows.Count, 2).End(xlUp).Row
ws.Range("B7:H" & lastRow).Interior.ColorIndex = xlNone
For Each cell In ws.Range("B7:B" & lastRow)
If cell.Value = searchValue Then
foundRow = cell.Row
ws.Range("C3:H3").Value = ws.Range("C" & foundRow & ":H" & foundRow).Value
ws.Range("B" & foundRow & ":H" & foundRow).Interior.Color = RGB(144, 238, 144)
Exit For
End If
Next cell
End If
End Sub
🎯 Perfect for:
✔ Business professionals looking to automate reporting
✔ Excel users who want to learn VBA for dashboards
✔ Anyone who wants to save time and improve productivity
💡 Like & Subscribe for more Excel tips and automation tricks! 🚀
🔔 Turn on notifications so you never miss an update!
🔗 More Excel & VBA Tutorials:
📌Follow me on Instagram and Titkok:
/ excel_vba_automation
/ excel.jacob