August 20, 2020
Display All Matches from Search in Userform ListBox
I've previously described how to use a form to search for a distinct value, like a unique ID. This time
Read More
August 20, 2020
I've previously described how to use a form to search for a distinct value, like a unique ID. This time
Read More
June 4, 2020
Let's say we need to assign staff to work different shifts and no person can work both early and late
Read More
March 18, 2020
I've written about using calendars/date pickers in userforms before but this one is particularly easy and flexible to use, even
Read More
January 28, 2020
I was recently asked to provide the ability to search a list of records (like a table) using a user
Read More
July 21, 2016
You have a workbook with lots of sheets and you want to do things like hide sheets, delete some sheets
Read More
September 4, 2015
If you've been following the previous posts in this series you'll know that by now we have a user form
Read More
August 21, 2015
Carrying on with the Excel form I created in an earlier post, I’m adding code to allow us to insert
Read More
July 9, 2015
When creating Excel userforms it seems like a good idea to check the data going into the form before adding
Read More
July 9, 2015
In my previous post about Excel forms the date picker I used was a 32 bit ActiveX control. If mentioning
Read More
July 2, 2015
Excel forms, or Userforms, can be used to collect information from a user, validate it, then enter that data into
Read MoreJuly 10, 2013
Written by Alan Murray of Computergaga. Form controls such as option buttons, combo boxes and check boxes allow you to
Read More