How to Create a Data Entry Form in Excel

Hope you enjoy the video. Let me know if you use or plan to use UserForms in the comments below

Microsoft is blocking the downloaded file

Hi, I am trying to put a button directly onto my spreadsheet that will open the automatic form to enter data into my table.

Perfect explanation 👌 Thanks ❤

great tutorial.

Is it necessary using "Call" whenever we want to call the public sub? What if we don't use "Call" so just directly the name of public sub?

Awesome video, I have one error where you add the list of dropdown items in the cb. When I insert the shLookup and run, it comes out woith an error that states "Variable not defined". Can someone please help me:
Public Function GetCountries() As Variant
GetCountries = shLookup.ListObjects("tbCountry").DataBodyRange.Value
End Function

Public Function GetDepartments() As Variant
GetDepartments = shLookup.ListObjects("tbDepartment").DataBodyRange.Value
End Function

do you have a code to add a search button

Great, that his mouse goes out of the view, and suddenly there is a list box. viola\.

Great video (and site). Very professional code. Thanks for sharing. Some remarks:

Loved the way a userform can be duplicated.

If user is allowed to select any cell in the “Staff” worksheet, to indicate the record to be updated or deleted, “New”, “Edit” and “Delete” buttons could be put directly in this worksheet, with the same functionalities. Thus, “formStaffList” could be skipped. (Albeit, in this case, this video, too.)

There are tutorials that discourage the usage of RowSource property, in favor of the List one. Probably because of Excel bug(s).(?)

There is a bug in “CreateNewID” method. If the last record is deleted, and a new one is added afterwards, the new one takes the Id of the deleted one. Instead, perhaps the last used Id could be stored in a cell of the workbook, and its value be incremented by one, whenever a new record is created.

Again, thanks for your services.

Your video is very informative and makes me want to learn more. However, I need instructions about one or two steps below this one to understand the VBA process.

Its good and looks nice but I find it easier to just use the spreadsheet for this specific example.

Great tutorial. Unfortunately, I'm only part way through it as I'm having some issues. I'm getting this weird error when I try to close the userforms in vba and when I try to save my macro-enabled spreadsheet. The error is "System error &H8000FFF (-2147418113). Catastrophic failure" Could this be the result of not having the appropriate references loaded in vba?

I can't believe i haven't used iif function in my coffee before. I never even thought of it.

I needed to create a form for Stock Management for my colleague, and this video was perfect talking me through my first VBA project. I will say I tripped several times with not being able to download the source code (Company blocked), however extremely happy with how it's turned out! Will be watching more of your videos!

the use of shStaff confused me. I used ActiveSheet in its place and made it to the next step. I must not have had shStaff set up, no clue just beginning

You are wonderful. This is straightforward and finessful coding and explanations. Thank you.

Hi, Thanks for this detailed file. If i want to make "Edit" on entering a "record number" , how to do that ?

Loved the video. Is it possible to create the form using listview and still have the ability to edit the entries? I like the grid lines of list view and hoping to incorporate it.

This is excellent. I need your help. How can I make data Base form that can allow me to enter marks of different subjects, and find position average, total,and prepare parents report cards automatic?

Is there any way to add a filter/search option to the listbox

I want to achieve something I think a bit more complex. But this is a good starting point. I’m new to this

Thanks a lot it looks very easy and nice

hi and thanks for your amazing vids. I have a problem soon..I cannot use the excel file with userform that I created while using window 10 after purchasing a macbook. My first question is, is there no userform support on macbook computers? My second question is, is there a way to convert the file I created with win10 to macbook? Thanks

Excellent, thanks!

My database that is used to populate the user forms have a number of cells with calculations in them - so they don't need to be filled in (or even seen) by the user. Do these cells (columns) have to appear on the user form (for add, edit) just because they are columns in the underlying database (i.e. "shStaff")?

thanks

If you have user form student register but can I upload excel file with the same information needed to enter in the user form box and when I upload it data of excel will automatically added to the list register student

......

.......

hallo paul, many thanks for the tuorial! i cannot get the download link to work! any ideas? regards, colin

Great tutorial. I do have a couple questions/issues. The first is what is a shlookup? I get an error on that in excel 2021.
GetCountries = shLookup.ListObjexts("tablename").DataBodyRange.Value

also me.options does not bring anything up and errors out as well. More than likely EndUser error. But if you have time to comment that would be great.

Paul is the BEST 👌 teacher of VBA. Thank you so much for your hard work & source code for us. Liked & definately Subscribed . Love ❤the tutorial. Looking forwarrd to more.👏

For anyone who's trying to follow and getting the object required error. You have to make tables for each combo box in Lookup sheet. Then go to Formulas -> Name Manager to edit the table names to "tb{table_name}"

Hi thx for all. Any Idear to change Height of the first Row (header) ?

Sequence numbers are not updated when we delete a record

Is there a way to lock the "header information" if all the data items get deleted.

Hi I'm work on a project and I learned a lot from your tutorial. As par of on going project, can you teach us how to create a search using a combo box as a criterion and when you enter the data that you want to search in the text box search the results will display in the list box and text box

Great job Mate!

Working perfectly!

gracias maestro!

Thanks for sharing. I have wanted to do this in previous uses but never got it all figured out. You make it look so easy. I will certainly give it a shot.

in minute 15, exporting the form: I get system error &H8000FFFF

Amazing!!! Thank you.

Awesome tutorial, have watched it several times. Thanks. Can you update the link to the download workbook?

loved the video, really helped me get my head around a couple of things - one thing - I cant download the source code ????? can you help please......

I thought I knew everything in vba ... just discovered the accelerator property 😂 so used to the VB "&" placed in the caption and was wondering why it wasn't implemented in vba lol... Thanks Paul, I love your videos👍

No Data entry form for HR without joining or leaving date , i know datepicker will add a bit complexity to the project but it would be nice if it was there

This was a good tutorial. I did get tripped up a few times following along but the included worksheet showed me the deviation so I thank you for that.

To take this further, refreshing the list in real time for adds and removes would have been cool. I could see how another list on the modfiy and edit page would give that update view real time... "people you just added" list. and when close that would be present on the initial list.

personally i would like to see role and group selection UI with the forms. thats where i am hoping to build some functionality with forms. thanks for the video

This was a really helpful video and I used it as a guide to make a data entry form for tracking failure events at wind farms. I would like to modify it to include some data validation such as making sure certain text boxes only allow dates or integers. It would be great to have a similar walkthrough of that.