How to Create an Excel VBA Data Entry Form with Update and Search Function - Full Tutorial

How to Create an Excel VBA Data Entry Form with Update and Search Function. In this tutorial, you will learn how to implement a Spinbutton, code Search, and Update function using Excel VBA, other functions used include the use of For Loop and selection Statement. This tutorial is ideal for beginners and advanced learners.

Join this channel to get access to perks and codes:

Channel Members can Download the Excel VBA Data Entry Form with Update, Search Function and modify it for their own personal use: Plus one other source code per month.
Total - 2 Source codes Per Month, only:

To support more videos from DJ Oamen, visit POamen Paypal

To Become a Channel member click on the link below to JOIN:

How to Create an Excel Data Entry Form With Search System:

How to Create Advanced Tic Tac Toe Game in Python

How to Create an Advanced Excel Data Entry Form With Search Function using Userform

How to Create Currency Converter with Foreign Exchange Rates in Python

How to Create Currency Converter with Foreign Exchange Rates in Python

How to Create a C++ Calculator Using Windows Forms Application in Visual Studio 2017

How to Create Tic Tac Toe Game in Visual C++ 2017 Using Windows Forms Application

How to Create a Piano Using Windows Forms Application in Visual C++ 2017

[ellewood]

Thank you so much for your tutorial! I learned a bunch!

[anthonyblee]

Hello Sir, I am one of your subscribers and I must say your videos are really outstanding. Can application of this such be integrated into google appsheet for sharing on phones?

[pkalamkhan]

Great Work Sir, One more important field is Picture.Then this was awsome.

[aishabee]

Thank you for your excellent tutorial. Is it possible to print just based on “the search result list” instead of printing all the data from the sheets? Thank you.

[janixakem]

greetings sir, your videos have been very helpful. i encounter a problem which is the delete function doesn't work when i want to delete data from another sheet is not the current sheet

[dougsmith]

Great video DJ Oamen, thank you for taking the time to do this. Am i missing something on the Update button... i cannot see where you have defined the 'updaterow' variable?

Code I have used is as follows which I am pretty sure is exactly as you show in the video:

Private Sub UpdateButton_Click()
Dim answer

Dim updaterow

answer = MsgBox("Confirm if you want to update the record?", vbYesNo + vbQuestion, "Update Record")
If answer = vbYes Then
Cells(updaterow, 1) = DateInput.Text
Cells(updaterow, 2) = PrevDayInput.Text
Cells(updaterow, 3) = GPTodayInput.Text
Cells(updaterow, 4) = EDStreamInput.Text
Cells(updaterow, 5) = EDNewPushInput.Text
Cells(updaterow, 6) = EDNewPullInput.Text
Cells(updaterow, 7) = NewOtherInput.Text
Cells(updaterow, 8) = FollowUpInput.Text
Cells(updaterow, 9) = DTAInput.Text
Cells(updaterow, 10) = SentToEDInput.Text
End If
End Sub

Thanks,
Doug

[ulquiorra]

Great video, thank you very much.

Please,
Suppose I am working with 4 different worksheets in my excel file and I have created a userform having a combo-box (with the worksheets as its content) and a list-box, how can I make the list-box display the data for a given selection from the combo-box?

[cosbywales]

Very good sir, I love it. But can you please create one in Python using tkinter. Please Captain Paul

[Dezadna]

wow very nice video, i wish more succes for you mr oamen,
is there a way to add a copy button that it can copy selected row into an other sheet ? i tried to add codes but it seems to not work for me, any help ?

[kathleeneller]

Thank you for your code. I resolved a few errors, but I'm still having a problem with the spin button stopping at the record at A100 in my spreadsheet. I modified your Excel spreadsheet to include 150 entries. I have the same problem in your UserForm with the spin button stopping at record at A100. Thanks in advance for your help.

[garcon]

Many thanks for fir you video I followed from scratch. I do however have one problem with the reset code. When I run it it this line For I=0 To Me. lstDisplay.ListCount -1. The Me.lstDisplay is highlighted
Any reason why this is happening

[chanmonanrie]

Hi, Captain! This string is highlighted in yellow "iSearch = Any solution for this issue?

[jiyoutv]

Can i buy the billing invoice that can search name, save, and add new bill amount but same customer name?

[leehartnell]

Hi, great video and I’m nearly there but search function isn’t working. My code is not throwing any errors but when I search it just says invalid search even though I can see what I’m searching in the list

[gemmariellebuenaflor]

Update button do not work. Error 1004 Application or object defined error pops out. I tried debugging and it points to this code.
Cells(updateRow, 1) = txtItemNumber.Text

ItemNumber is my textbox Name. I hope you can help with this problem. Thanks!

[zakariakanso]

im stuck at (addnew.Offset(0, 0).Value = txtref.Text) telling me variable not defined. when i press F5 please help

[rnr]

In cell A1 I typed Reference No. However my lstDisplay shows the header name as Column A. How do I make Reference No the Column name? Did I miss a step?

[faridahmed]

Delete Button is not working, Error Says: Variable is not defined- The variable is --- lst.Display. What should I do?

[mikhab]

great video sir but i cant get the file. a little help please. Thanks

[chanmonanrie]

Sir, I can't figure out why the "lblDate.Caption = Format (Date, "ddd d mmm returns a compile error message: variable not found? Any help?