Userforms Archives • My Online Training Hub

Hide, Delete and Sort Sheets With VBA Userform

July 21, 2016 by Philip Treacy 8 Comments

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 […]

Add Data to Combo Box Drop Down List in Excel Form

September 4, 2015 by Philip Treacy 6 Comments

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 […]

Excel Forms – Insert, Update and Delete

August 21, 2015 by Philip Treacy 44 Comments

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 […]

Excel Form Data Validation

July 9, 2015 by Philip Treacy 14 Comments

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 […]

Excel Date Picker

July 9, 2015 by Philip Treacy 14 Comments

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 […]

Excel Forms

July 2, 2015 by Philip Treacy 44 Comments

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 […]

Excel Form Controls

July 10, 2013 by Mynda Treacy 11 Comments

Written by Alan Murray of Computergaga. Form controls such as option buttons, combo boxes and check boxes allow you to add interactivity to your spreadsheets. They are familiar to users whether they are Excel savvy or not, making your forms user friendly, quick and easy to complete. Form controls can be incorporated into your Excel […]