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

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

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

This is almost perfect. It would be much better if you could search for containing strings so like Searching for product name and searching for a string would bring up results and then a next button would allow you to scroll through the results - instead of just giving one result.

Does not like it if Option Explicit is on

Can I know different between the "product_id = Trim(TextBox1.Text)" instead of "product_id = TextBox1.Text " without Trim fnction?

Hi can you add a code if product I’d not found in the search

Thank you very much, it's very useful.

What If I need to build sheet2 by a form using sheet1 datas....

Hi Bro.. Good but if product id not found , it has to show some message and also deleting options . should have been better. I know this is basic but these are all mandatory.

mine is not running can you help me

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?

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

i got run time error '438'

Hi
How we have to change the code if we have different sheets and we want to update a field on same userform. For eg, if we have same product id for two different cities, which we can put as sheet name. Then we can change product name for specific city into their sheet by this userform.

I really like this example!... Congratulations. i'm 68years men and i start now to understand something .Thanks

genius

Thanx

Nice and simple.

Thank you

Hello, for me, i get a mistake, because "i" is not defined... did you do that somewhere else?

HI, Great Tutorial, I have to search the values according the reference value. which is in 6th column. how to code that?

Can you add code if you type the product name and then search and all the other fields ...

Убрать режим инкогнито

Уберите канал инкогнито

Введите нормальную работу каналу ЮТюб

Отключить канал инкогнито

i got stuck in the Userform , it looks like its not available in MAC. I need this thing that you're doing so i can put in our inventory and work it seamlessly.

U r amazing my friend 😘😘😘

Amazing, Thanks very informative. How about incorporating message for records not found within the sheets? thanks

Hey great Video bro it made my work so easy, but i need help, instead of extracting data after typing it in box and search, will u pls show how to exract data frm dropdown list in the same user form with add buttion option??

Good to have your lecture, it's so clear ........

SIR, ALL IS GOOD, BUT VARIABLE IS NOT DECLARED !

Thank u very much

Thanks for this video! However, if I have a lot of columns and rows, are there any ways I can do that in a shorter way or I have to do it one line by one line?

Very subtle explanation. Very useful. Screen shot itself is very informative

Beautifully explained. Left no place to say anything negative.

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

Thanks in a million. Great content. Awesome imagination. Grade: A++💥

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

Great, I was exactly looking for it, thanks bro great work 🙏

Hi, when building a user form, how do I set via search and update data so it searches and changes records vertically instead of horizontal rows?

What if in my table the product ID is not unique, can I still search and select the correct product name that i want to be displayed in the form? The product ID in my data can have two or more different product name.

Nice and simple, thanks. How does the code work without declaring Lastrow and i as datatypes?

any way to make it so its not case sensitive I've tried Lcase ect but no luck

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.

how to show 2 rows dear?

Thanks

Thanks a million sir! Used this form as a stock-lookup/update for inventory

I have been looking for a streamlined way to do this and your method works great! Thank you so much. One issue though: What if the user searches for a value that does not exist in the data? There needs to be a MsgBox indicating the value was not found. When I run the code with data not found, it just stalls and does nothing and the userform stays open.