Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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, 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 …
