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: Userform

Spin Wheel in Excel
Templates

Dynamic Spin Wheel in Excel

June 14, 2020February 20, 2025 PKComments Off on Dynamic Spin Wheel in Excel
In this article, we have created a dynamic spin wheel in Excel. You can add or remove the name in spin wheel dynamically. You can change the rotation range, speed
Read More
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
Data Segregation Tool
Templates VBA

Data Segregation Tool in Excel VBA

May 10, 2020February 23, 2025 PKComments Off on Data Segregation Tool in Excel VBA
In this article, we have created a Data Segregation Tool using Excel VBA. It is ready to use Tool to segregate your data into multiple sheets for Multiple files. Click
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
33 Useful VBA Shortcut Keys (Full List with Examples)
VBA

33 Useful VBA Shortcut Keys (Full List with Examples)

May 30, 2019October 10, 2026 PKComments Off on 33 Useful VBA Shortcut Keys (Full List with Examples)
These 33 useful VBA shortcut keys help you write, test and debug macros faster and lay out UserForms in seconds instead of minutes. Below you will find all 33 in
Read More
VBA Multilevel Dependent Drop-Down in a UserForm
VBA

VBA Multilevel Dependent Drop-Down in a UserForm

November 11, 2018October 9, 2026 PK0
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
Read More

Posts pagination

Previous 1 2
  • 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