New: NextGenTemplates Academy - video courses on Excel formulas with AI and Pivot Tables & dashboards. Early-bird: 20% off with code EARLYBIRD20 - first 20 orders only. See the courses →
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: List Box

Universal Searchable dropdown list
VBA

Universal Searchable Drop-down List in Excel

May 31, 2020October 10, 2026 PKComments Off on Universal Searchable Drop-down List in Excel
In this article, we have created a universal searchable drop-down list in Excel. It is useful when you have multiple items in your data validation drop-down list. You can use
Read More
Sales Score meter Chart -V2
Charts and Visualization

Dynamic Sales Score Meter Chart

April 19, 2020February 23, 2025 PKComments Off on Dynamic Sales Score Meter Chart
In this article, we have created a dynamic sales score meter chart. In this chart we have displayed the sales core on a speedometer chart. We have displayed the sales
Read More
Inventory Management form
VBA Templates

Inventory Management form in Excel

March 1, 2020February 18, 2025 PKComments Off on Inventory Management form in Excel
Inventory Management system is very useful for any business. We have created this ready to use template for Sales/Purchase and Inventory Management Form in Excel VBA. Click to buy Inventory
Read More
Data Entry Application in Excel VBA with a List Box
VBA

Data Entry Application in Excel VBA with a List Box

September 16, 2019October 9, 2026 PKComments Off on Data Entry Application in Excel VBA with a List Box
A data entry application in Excel VBA gives you one clean window where you add a record, see every saved record in a list box, double-click one to edit it,
Read More
Dynamic Target Vs Actual Chart
Charts and Visualization

Target Vs Actual Sales Dynamic Chart

July 9, 2018March 8, 2025 PK0
When it comes to tracking sales performance, a dynamic and interactive chart is often the best way to go.  In this article, we’ll show you how to create a Target vs
Read More
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy