Excel VBA Userform to Search and Update Data - Excel VBA Userform Example

This Excel VBA Userform example explains, how to search and update excel sheet data with userform.You can update existing data using UserForm in Excel VBA. If you want to search data
on Excel worksheet by entering Specific ID in Text Box and UserForm will display all relevant data and in case of any modification, you can change through Userform.

Watch UserForm Real Time Examples at below link :

[mariamxxxx]

I just followed your instructions, but it doesn't really work, when I press on "debud", i see that it highlights the and it says "Lastrow=Empty", what am I doing wrong?

[prbhat]

Sir Thank You So much. But I have One Problem. For Text Box 1 Code I think this is Search Button. I want For this button msg box if data ot found. can you help me please

[rezarohoman]

nice one week for me to get working thank u

[royokinawa]

Great information. Followed the steps and everything is working perfectly. Thank you. Do you have a VBA tutorial that uses the same concept but allows the user form to update multiple rows? Example: The search parameter of Completed will display a select number (10-15) work orders. Once populated a date will be added to update those orders.

[igoravsharma]

HELLO SIR

I HAVE A QUERY ABOUT SERCH AND DISPLAY OPTION

MY QUSESTION IS THIS

I CAN SERCH ONLY BY PRODUCT ID ??

I CAN'T SERCH BY PRODUCT NAME ?
QUANTITY ?
CITY ??


PLZ REPLY

[bchotai]

Thank you - not sure why I am getting Complie error: Variable not defined error on Lastrow = Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row

Private Sub CommandButton1_Click()
Dim product_id As String
product_id = Trim(TextBox1.Text)
Lastrow = Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row

For i = 2 To Lastrow
If Worksheets(Sheet1).Cells(i, 1) = product_id Then
TextBox2.Text = Worksheets(Sheet1).Cells(i, 2).Value
TextBox3.Text = Worksheets(Sheet1).Cells(i, 3).Value
TextBox4.Text = Worksheets(Sheet1).Cells(i, 4).Value
End If
Next
End Sub

[georgekhaba]

time table :
@4:42 creating the form
@10:41 the code to find data
@16:34 to update data

[tomkochka]

This was so easy to follow and just what I needed for a user form I was designing at work. Thank you!

[alvingapay]

Great video Excel Destination. can you please add a code or teach us how to put a message if the PRODUCT CODE is not listed when we click the search and also message for "record has been updated" when record has been updated. thanks and more video please.

[ROVideos]

This is the best video I've found on the subject. Short, easy to follow. You are great.

[greatlakeschorus]

This Form works works better than the previous form that you sent me. I will Email you with a question or two. Thanks very much for your help!

[alexsanchez]

Is there a way to have a message box show up if you try to enter a product ID that is not already in your table? For example If I look for Product ID 2004 but does not exist in your table. I would like a message box to pop up.

[sameerpendharkar]

How to search for the data in 19th column in excel. My sheet has a data stored from 19th column. I tried using your code but it is not searching . give me blank output.

[dinkarshinde]

Very Nice, Thanks for the Same. Please give me code for Multiple criteria Search through UserForm

[rahulg-lh]

Dim lastrow As Long ' Declare the variable lastrow
Dim i As Long ' Declare the variable i
please add this

[kendallperkins]

I get an error on the update command. It says “compile error variable not defined”. The debug highlight the “lastrow =“

[DeepuMathewgoldeneye]

If the product I'd meets more than one row in worksheet how will you update. If we only want to update few rows that meets the if statement how will we go to next row which is having the same product Id

[SanjayMahato]

Display list of items like sales of same products in a day month

[fwmfwm]

This example is good to me. However, could you tell me how to add "Delete" record code on that example ? If possible, it would be great if you could send me the excel file . Thanks !

[kushalmukhoti]

Great Video. Very simple and easy to understand. Is there any way that I can edit the search criteria itself? Suppose, I want to rectify a wrong customer ID. Is there any way to do this without deleting the whole entry and reentering the same after correction?