Excel VBA UserForm Search, Display, Add and Delete Data - Advanced UserForm Example

This Excel VBA Tutorial explains how to create UserForm to search find and return data. Also how to add and delete data through Userform.

Watch more UserForm Examples at below link :

[kushalmukhoti]

I am an octogenarian having no formal computer education. I have prepared the same User Form after watching your video. First, I prepared the User Form following your step-by-step guide and then copied the VBA codes on my computer notepad. After overcoming the initial hiccups of navigating from one window to another window, and pasting the codes under different coding heads one after another, I have ultimately succeeded to prepare a perfectly working User Form. Thank you very much. God bless you.

[chanmonanrie]

Thank you so much! Your instructions are so crystal-clear and are easy to follow. I successfully created my own UserForm and is now fully functioning. More power to you, Mr. Wizard!

[bhuapureducation]

धन्यवाद भाई। मुझे आपका व्याख्यान बहुत पसंद आया। नए वीडियो जारी करने के लिए धन्यवाद

[woxz]

It's really what I'm looking for, presented in a very good way and simple. Thank you

[dariatomashevskaia]

Many thanks from Russian students!!! You helped us to comlete our assignment on Business Analitics in Excel

[flpouse]

Thank you so much u saved my life, u have such clear instructions

[diegorigl]

Great Video, thank you, well explained, just one question, I am excel beginner so, how I can do all the same, but the first TextBox1 is a ComboBox1 so will show a list from the data, its that possible to do it

[vivekphadke]

Excellent, aptly simplified so that even a beginner comprehends. Thanks

[obbynomwa]

Appreciated, this made my tracker be too easy, done updating details, search, clearing form and exit. Thanks, great tutorial

[blgrth]

This is a great video for a basic spreadsheet/database and I shall utilise parts of it in future projects. What it doesn't cover, however, is updating a record. Do you have a similar video that covers updating records?

[markjosephramos]

Hi, your tutorial is awesome! what should I do if I'd like to edit it after I searched for it?

[osoriomatucurane]

Awesome Tutorial, Sir. For better readability you could have considered adding comments along the code, name the textboxes to be concise, descriptive and meaningful. Additional improvement could have been attained by assigning a variable such as wst to the object sheet1 as : Set wst = ThisWorkbook.sheets("sheet1") or using the sheet code.

[UncleBright]

I have followed this tutoriral carefully and created a userForm with a all the command buttons and codes with success.Thank you once again.
Sir, please I have other questions. (1) when I click on the DELETE Button, I would like to see a Message Box asking me *" you sure you want to delete"?*
(2) Can we have another Button that can *Updates* any changes made to the data?
(3) I managed to put a PDF file into a cell. How can I print it out with a help of a PRINT Button?
Thank you!

[patrickmartin]

Thanks for this tutorial. It is exactly what I needed. Quick question...how would you code for a "replace data" button. That is to say, suppose you had a cell full of customer interaction notes. If I did a "Search and Display" for a current customer that would display the latest notes. After today's interactions I would like to add to the previous interaction notes within the same cell where they are now. This way I can keep a running log of appointment notes. All other fields would remain unchanged. Much appreciated

[ahmedaseri]

Thank you, sir, your tutorial is very good it helps me a lot can you please make print invoices, in the same user form

[babulasabar]

Thank you sir. Your tutoring us very easyly. Nice Sir. Long leave.Godbless you Sir.

[nirman]

Thanks for your knowledgeable Video. but I hope this user form is only for Unique codes to be search means one of the primary key to be consider. How to display duplicate data I need to know?

[mikeheilig]

This is perfect for what I need to do. One thing I noticed is when I add data, it doesn't match the formatting in the table. For example, the font is different and it is not center aligned. Do you need more code to do that?

[jigarshah]

This is wonderful explanation. thank you so much.
one question - If in the searched textbox. instead of text, I have hyperlink, is it possible to open that hyperlink?

[shellykomar]

HI Great explanation and clear instructions. Thanks