Search for Data In Excel Database with UserForm




About this tutorial:

Video duration: 11:25
How to search for data in Excel database with UserForm.
Details available at this website link:

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

39 thoughts on “Search for Data In Excel Database with UserForm

    Gerard van Eggermond

    (November 7, 2019 - 2:40 pm)

    Hello, I have watched the video about the advanced userform, I found it intresand, I want to know more about the buttons used here, I want to use the delet and update button in my form so that I can delete names and then add a new one update. Could you help me?

    Sta Ima

    (November 7, 2019 - 2:40 pm)

    Dr. Takyar, I've searched through several of your videos, and they're great!

    I'm trying to add a level of complexity from this video by pulling the data from a closed spreadsheet. Even if I had to copy the data into the current spreadsheet, then delete it afterward, that work would. Could you please point me in the right direction on getting this to function? Thank you in advance!

    Jose Lezana

    (November 7, 2019 - 2:40 pm)

    Muy buen instructivo. felicitaciones y muchas gracias por compartir Mr Kumar

    Arslan shani 03487997052

    (November 7, 2019 - 2:40 pm)

    sir main kam karna chahta Hoon k userform mein koi data search karna hoe to combo box 1 Laun usme farz kia aap registration number roll number and name yeah combo Box 1 Main Naam add Karun Tu Jo usme Agar register number select karun to textbox 1 search box Mein register number add karo to number Kahe data show Jaye aur Agar roll number select Hoon to roll number wale form se textbox1 Mein roll number ki jagah select Karun to text box man roll number data shows ho jaaye

    Anees Bhan

    (November 7, 2019 - 2:40 pm)

    Gives me error 9 on CurrentRegion.Rows.Count function.
    -_-

    Bayu Saputra

    (November 7, 2019 - 2:40 pm)

    Thanks, very usefull !

    Giacomo Maestri

    (November 7, 2019 - 2:40 pm)

    thanks! what about case sensitive fix?:-)

    Ben Benitez

    (November 7, 2019 - 2:40 pm)

    Great video Mr Takyar.

    jishnu km

    (November 7, 2019 - 2:40 pm)

    Sir next button code pls…

    Joyce Jas

    (November 7, 2019 - 2:40 pm)

    Wow!  what a treasure.  Mr. Kumar makes it so easy to learn.  That's a gift.  Thank you sir.

    Massimo Lorenzi

    (November 7, 2019 - 2:40 pm)

    beautiful, where can I find the tutorials to make this userform from the beginning?

    Elad Ngujede

    (November 7, 2019 - 2:40 pm)

    Thank you so much you have help me a great deal Sir . I have a question What if you had two same name . how do you code so next should show the next name. so if you had two laura summers how do you make a code to show next laura when you hit next button.
    thank you

    Meet Bhayani

    (November 7, 2019 - 2:40 pm)

    What if I had two people with same name

    Will it saw the data for both

    Or an error

    Please reply soon

    Ignacio Mosquera

    (November 7, 2019 - 2:40 pm)

    It doesn't work

    Gurjeet Singh

    (November 7, 2019 - 2:40 pm)

    when i press search button then message box appears " Name not found". Now i press next button then my userform becomes blank and on pressing back next buttons no record is appearing in the userform

    Awadh Binamro

    (November 7, 2019 - 2:40 pm)

    thanks Sir…can you upload the work file

    Dipti Ranjan Mishra

    (November 7, 2019 - 2:40 pm)

    Thanks Sir

    Eduard Abasula

    (November 7, 2019 - 2:40 pm)

    Hi sir i have a problem of my data entry project it search only in one textbox is there possible that it can search can search in other textbox to get the data ? plsss answer my question

    Uday Waghmare

    (November 7, 2019 - 2:40 pm)

    Dear sir,
    How to generate weekly , monthly report from data on date base(start date and end date). The particular sheet should be generate on the specific column on report sheet.
    I am working on VBA code but I'm facing difficulties:
    1 When I click the command button to continue on the same sheet but it directly opens the new sheet. I have created the specific sheet so it should be continue on same sheet. When I'm entering a particular date data, I want that date data should be generate in that specific sheet and the column I have chose and it should not generate the new sheet.
    I want specific sheet or same sheet
    Please help me to clear this doubt.

    Kier Tee

    (November 7, 2019 - 2:40 pm)

    Good day sir.. i have a question. what if ill seach for the data from another workbook. what code should i use..
    im using this code but its not working

    Private Sub cmdsearch_Click()
    Dim totRows As Long, i As Long
    Dim data As Workbook

    Set data = Workbooks.Open("Z:KIERTestdata.xlsx")
    Worksheets("Sheet1").Select
    application.screenupdating = False
    totRows = Sheet1.Range("A1").CurrentRegion.Rows.Count
    For i = 2 To totRows
    If Trim(Sheet1.Cells(i, 1)) = Trim(txtname.Text) Then
    txtname.Text = Sheet1.Cells(i, 1)
    txtaddress.Text = Sheet1.Cells(i, 2)
    txtcnumber.Text = Sheet1.Cells(i, 3)
    txtcode.Text = Sheet1.Cells(i, 4)
    End If
    Next i

    ActiveWorkbook.Close

    End Sub

    but its not working…. can you help me sir? thank you.

    محمد أبو عبدو

    (November 7, 2019 - 2:40 pm)

    Thanks … Thanks … Thanks

    Priyal Tailor

    (November 7, 2019 - 2:40 pm)

    how to display this searched data in listbox

    Parker Cirino

    (November 7, 2019 - 2:40 pm)

    love this man. great teacher

    lorena hernandez

    (November 7, 2019 - 2:40 pm)

    What if there are multiple students with the same name ?

    Jayaprakash Shetty

    (November 7, 2019 - 2:40 pm)

    Hello Sir
    How can i search Same Name in the second row with different grade or marks

    for example
    Ramesh A 94
    Suresh B 82
    Ramesh C 73

    Tubpheej Teb Lauj

    (November 7, 2019 - 2:40 pm)

    Once you have added the second message for name search was not found and you do a search without entering a name, you'll get first message as "…enter the name you wish to search…." and when you click ok then the second message will be "name search is not found.".  Can we prevent the second message from showing/popping up until we enter a name that's not in the record?
    Thanks,
    Fong

    gulam malek

    (November 7, 2019 - 2:40 pm)

    hello sir
    sir excle me jo pure saal ka data he use mese koi se matha me kitani entrys he use kese surch kare koi formula bataiye

    amir elhamy

    (November 7, 2019 - 2:40 pm)

    I have a problem with Search Function

    Rahul Sharma

    (November 7, 2019 - 2:40 pm)

    thank you sir, plz explain how we can search data form sheet1,sheet2,sheet3 if headings are same in all sheets with single userform and update , delete searched data too

    Joellie NB

    (November 7, 2019 - 2:40 pm)

    my data are 76 but can only search up to 64, how to fix?

    Abdul Malik

    (November 7, 2019 - 2:40 pm)

    Hi my data is with date and name how can i search and update plz help

    IIVIOVIV

    (November 7, 2019 - 2:40 pm)

    Hey Doc,If you find the time…How do I relate my Search to Column (C)? I tried Activating Cell and Sheet/Changing names but it keeps relating to Column A.Below Code won't work.totRows1 = Sheet4.Range("C1").CurrentRegion.Rows.Count         Thanks

    IIVIOVIV

    (November 7, 2019 - 2:40 pm)

    Thanks again. You Rock this shit.

    LFYR

    (November 7, 2019 - 2:40 pm)

    Yahi video Hindi me kab banaoge

    Nijam Ismail

    (November 7, 2019 - 2:40 pm)

    Help it not work for me :c

    Simpatic Fiel

    (November 7, 2019 - 2:40 pm)

    Bonjour Sir. J'ai un problème au niveau de la modification d'un enregistrement sur excel. Le critère de recherche est fait sur la base du numero de dossier et ca se fait via un textbox au lieu d' une combobox. Merci d'avance pour votre aide.

    Sahajamal Sekh

    (November 7, 2019 - 2:40 pm)

    please. give the link to download the excell file which was shown as thumbnail. I need to work directly… please

    Chirag Bhatt

    (November 7, 2019 - 2:40 pm)

    This is very useful videos for me it will use me many ways but i just want to know what if sheet1 – cell A1 contain duplicate value how to search for duplicate

    Rajesh Thacker

    (November 7, 2019 - 2:40 pm)

    sir
    muje data entri form kaise banana hai is bare me book milti hai hindi me agar milti hai to muje leni hai

Leave a Reply

Your email address will not be published. Required fields are marked *