• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Userforms

Display All Matches from Search in Userform ListBox

Display All Matches from Search in Userform ListBox

August 20, 2020 by Philip Treacy

I've previously described how to use a form to search for a distinct value, like a unique ID. This time I'm using the Find and FindNext methods to search a table for all results matching my search string. You don't have to use a table, you can just as easily search a range. Find/FindNext allow …

Read moreDisplay All Matches from Search in Userform ListBox
dynamic data validation lists in userforms

Dynamic Data Validation Lists in Userforms

June 4, 2020 by Philip Treacy

Let's say we need to assign staff to work different shifts and no person can work both early and late shifts. Using data validation lists we can assign someone to the shifts, but having assigned that person to the first shift, it would be useful to remove their name from the list so they can't …

Read moreDynamic Data Validation Lists in Userforms
Excel Calendar (Date Picker) to Use in Worksheets and Userforms

Multi-Language Excel Calendar (Date Picker) for Worksheets and Userforms

March 18, 2020 by Philip Treacy

I've written about using calendars/date pickers in userforms before but this one is particularly easy and flexible to use, even direct from a worksheet. Thanks to our resident Excel guru Catalin for putting me on to it. It was developed by Trevor Eyre and you can read more about it here. You can download my …

Read moreMulti-Language Excel Calendar (Date Picker) for Worksheets and Userforms
search for data with userform

Searching for Data With a User Form

January 28, 2020 by Philip Treacy

I was recently asked to provide the ability to search a list of records (like a table) using a user form, and then populate the fields of the form when the record was found. The data can then be checked or modified before saving back to the workbook. This post looks at how to create …

Read moreSearching for Data With a User Form
Hide, Delete, Sort Sheets with VBA in Excel

Hide, Delete and Sort Sheets With VBA Userform

July 21, 2016 by Philip Treacy

You have a workbook with lots of sheets and you want to do things like hide sheets, delete some sheets or just sort them. By using a very simple userform and some VBA we can do these things with a few clicks of our mouse. The Form The forms consist of one ListBox and four …

Read moreHide, Delete and Sort Sheets With VBA Userform
add data to combo box drop down list in excel form

Add Data to Combo Box Drop Down List in Excel Form

September 4, 2015 by Philip Treacy

If you've been following the previous posts in this series you'll know that by now we have a user form that allows us to enter data into a table, and allows us to update and delete existing records. If you haven't read the other posts about Excel Forms, here are the links. Excel Forms Create …

Read moreAdd Data to Combo Box Drop Down List in Excel Form
Excel forms, insert, update, delete data

Excel Forms – Insert, Update and Delete

August 21, 2015 by Philip Treacy

Carrying on with the Excel form I created in an earlier post, I’m adding code to allow us to insert new records into any row of the table (not just at the bottom of the table), delete records and update existing records. Related Posts: This is the last part of a series of posts I've …

Read moreExcel Forms – Insert, Update and Delete
excel form data validation

Excel Form Data Validation

July 9, 2015 by Philip Treacy

When creating Excel userforms it seems like a good idea to check the data going into the form before adding it to your sheet. Once the data is in your sheet you can use other methods like conditional formatting to highlight errors or unwanted data. But it's good to stop the errors before they get …

Read moreExcel Form Data Validation
excel date picker

Excel Date Picker

July 9, 2015 by Philip Treacy

In my previous post about Excel forms the date picker I used was a 32 bit ActiveX control. If mentioning 32 bit ActiveX controls makes your eyes roll back in your head, then this post is for you šŸ™‚ This date picker is implemented as a VBA class. Which means all you need to do …

Read moreExcel Date Picker
excel userforms

Excel Forms

July 2, 2015 by Philip Treacy

Excel forms, or Userforms, can be used to collect information from a user, validate it, then enter that data into your worksheet. In this post I am going to show you how to create a form in Excel that gathers data, then populates a table for tracking expenses. This is meant as a simple example …

Read moreExcel Forms
  • Go to page 1
  • Go to page 2
  • Next
  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.