Userform in Excel | Add Data | Search Data | Update Data

Поділитися
Вставка
  • Опубліковано 7 лис 2024

КОМЕНТАРІ • 401

  • @Health_Loksewa_Teacher
    @Health_Loksewa_Teacher 4 роки тому

    apki video dekhkar maine userform banaliya sucesfully .
    maine koi computer ki trainung nahi li hai .
    Thanks sir .

  • @hiteshvashistha868
    @hiteshvashistha868 5 років тому

    Thanx video Bahut Acha h samjana ka tarika great

    • @daoodcomputers
      @daoodcomputers  5 років тому

      Thanks for watching
      Watch my latest videoEmployee / Student userform with photo
      ua-cam.com/video/Lq-UTNurhFc/v-deo.html&lc=UgzDOQbaXTDYZOdNH8B4AaABAg

  • @Lovesinghbgp
    @Lovesinghbgp 3 роки тому

    आपका समझाने का तरीका बहुत अच्छा है आपको 🙏🙏🙏 है ।

  • @ISAKBSHAIKH17
    @ISAKBSHAIKH17 2 роки тому

    PARVEJ BHAI ASLWLKMRBM..JAZHAK ALLAH AAP K VIDEO SE BAHOT SIKHNE MILA..ALLAH BLESS U ALWAYS..
    BHAI AAP SE RIQWEST HAI K AAP VISUVAL BESIC K FUNCTION, BUTTON,toolbaar KO DITEL ME BATAYE PLZ..

  • @nazeeratp
    @nazeeratp 5 років тому +1

    You description about VBA programming in the sample is absolutely very much effective, and your way of explanation is simply superbbbb.... keep it up bhai... I have not only designed a form and I had put picture on the form also.... thank you very much bhai..

  • @ABDULLAHMALIK
    @ABDULLAHMALIK 3 роки тому +1

    very nice and informative, thank you Sir

  • @roshanabeysinghe685
    @roshanabeysinghe685 4 роки тому +1

    It is very good video , thank u god bless u

  • @DebugWithShubham
    @DebugWithShubham 6 років тому

    are sir apki jinti tarif kare kam hai.. one of the best teacher in Excel..

  • @anshchamling203
    @anshchamling203 2 роки тому

    Thanks for making good videos of userform.

  • @shridhardevagekar266
    @shridhardevagekar266 2 роки тому +1

    Thank sir ur explanation superb

  • @md.rashedkhan9530
    @md.rashedkhan9530 5 років тому

    I REALLY APPRECIATE ....... NOW I AM FIDDA....... ON YOUR TEACHING...... WOW............ REALLY THANKS A LOT LOT OF CRORE..........
    LOVE YOU BOSS AGAIN THANKS.....

  • @sivaprasad3424
    @sivaprasad3424 6 років тому +1

    Dear Sir,
    So kind of you to upload this video as my be you noticed that many request has been made by me for this video. You have made my day. thank you very much. I admire the teaching style many people like myself has been benefited form your video. Once again thank you for your great work.
    Kind regards.

  • @ninjalimited3270
    @ninjalimited3270 5 років тому

    Awesome Video. Most Helpful. Hope get more useful advance excel tutorial videos like this.

  • @mixture6520
    @mixture6520 6 років тому +1

    salam sir g...
    bohot intezar kia is video keleye....
    app ke tutorials ke methods bohot ache hae .

  • @alonsocardenas1398
    @alonsocardenas1398 4 роки тому +1

    Thank you for sharing your knowledge very useful

  • @ritishchakraborty8620
    @ritishchakraborty8620 4 роки тому

    Thank u for this very useful tutorials on creation on user form. Pls tell the process of colouring the form

  • @harshdas7009
    @harshdas7009 5 років тому +1

    First of all thank u very much, u have saved our money and time by this useful tutorial, bhagwan apko bahut tarraki de..
    Mai ek search button banaya , lekin ye case sensitive hai, how to make a search button which is not case sensitive

  • @alikhan110786
    @alikhan110786 2 роки тому +1

    you are awesome sir.
    thanks a lot a lot

  • @naveensingh3267
    @naveensingh3267 5 років тому +1

    Thnku so much sir...i want to learn macro...your video..was very helpfull..i learn first time how can we make userform...and wht is userform...

  • @usmanottakkandathil6847
    @usmanottakkandathil6847 4 роки тому

    Good video, very useful and thanks

  • @alphonsekujur794
    @alphonsekujur794 4 роки тому

    Thank you so much. it is very much helpful and useful.

  • @rajanphadke
    @rajanphadke 4 роки тому

    thanks for very useful information

  • @NisarAhmad-xw1oj
    @NisarAhmad-xw1oj 6 років тому

    Sir apkey sare videos very helpful hai. Loving from pakistan ❤

  • @Ragala_pallakilo
    @Ragala_pallakilo 4 роки тому

    Well explained. Just have subscribed your channel

  • @finallytech.
    @finallytech. 5 років тому

    very useful video .. thank you very much.. can we make some application through this? plz advise

  • @santoshbabu34
    @santoshbabu34 4 роки тому

    Sir aapke video's super hai
    Mene bahut kuch seekha hai aapase
    Sir mera upadate work nahi ka raha
    Aur sir school students ka user form bhi banaiye

  • @quincyirang2543
    @quincyirang2543 4 роки тому +1

    hello sir good job,
    love your work
    I have question.
    Could you show how create next and back button in that userform

    • @daoodcomputers
      @daoodcomputers  4 роки тому +1

      Yes, sure

    • @quincyirang2543
      @quincyirang2543 4 роки тому

      Daood Computer Centre Thank you Sir. If you uploaded already help me know by giving the link Sir.
      Thank you Sir. You have incredible talent in programming world. God bless you.

  • @balajikendre1985
    @balajikendre1985 6 років тому

    Very useful.Sir,Please make video on data validation in userform.

  • @skysingh4u
    @skysingh4u 5 років тому

    Very easy and nice sir thank-you so much

  • @gajendrasingh9486
    @gajendrasingh9486 3 роки тому

    Thank a lot...I make it same......I make 1st time...

  • @vandanachiluka3263
    @vandanachiluka3263 5 років тому

    Very Useful and such simplified explanation 😀 Appreciated, keep it up😉

  • @aksheysharma3253
    @aksheysharma3253 4 роки тому +1

    You are sach a talented sir

  • @muraliiyer7850
    @muraliiyer7850 4 роки тому +1

    superb bhai.. keep it up

  • @mohammedakram6436
    @mohammedakram6436 5 років тому

    nice video
    valuable information

  • @ashu76mac
    @ashu76mac 5 років тому

    Really very useful and understandable

  • @horilalsoni
    @horilalsoni 6 років тому

    Excellent explaining.Thanks a lot

  • @ranchhodkoli143
    @ranchhodkoli143 6 років тому

    Thanks sir isi video ke wait me tha

  • @khanmohdasif
    @khanmohdasif 3 роки тому

    Thank you very much for such a usefull video
    Can you make another video how to search by name or any other detail available in sheet even they are repeated more than one time and can see how many times are same name or items available in sheet

  • @tanzindhondup8007
    @tanzindhondup8007 3 роки тому

    It's wonderful. Can you please create student's report card using visual basic

  • @indranathroy2768
    @indranathroy2768 5 років тому +1

    Excellent Video thank you

  • @godofliberty3664
    @godofliberty3664 4 роки тому +1

    Excellent 👍

  • @maheshagrawal1086
    @maheshagrawal1086 4 роки тому

    I have seen your video, I have altered userform for warehouse entry.
    All the commands are working good.
    1.Now I want to add this entries from master sheet to different sheets on basis of stake number(unique no.)
    2.And this same goes with different ledger on basis with name.
    3.on the basis of item
    Please show the coding for same
    Thank you

  • @vinaynimje97
    @vinaynimje97 5 років тому

    VERY NICE VIDEO... I HAVE LEARED VERY MUCH FORM YOUR VIDEO....HOW TO SAVE USERFORM DATA IN ANOTHER EXCEL WORKBOOK IN ANOTHER LOCATION,, FURTHER PLEASE GIVE DETAILS OF DATE FORMAT IN USERFORM

  • @dilipbiswas166
    @dilipbiswas166 Рік тому +1

    Thnx it's helpful

  • @muhammedwaleedashrafquresh1671
    @muhammedwaleedashrafquresh1671 3 роки тому

    Love You Sir
    From Pakistan

  • @Prashantgaming2155
    @Prashantgaming2155 5 років тому

    Sir, I liked this video, thank you very much for this, make an invoice bill on VBA. In which the data of the invoice bill created is automatically saved.
    👌Thank you 👌...........

  • @sanjoydutta4340
    @sanjoydutta4340 4 роки тому +1

    Hi Sir, thank you for this video, it's very useful. I need your help regarding data transfer to a separate excel file. I want to transfer data from userform to a Protect Excel file.

    • @sanjoydutta4340
      @sanjoydutta4340 4 роки тому

      Is any coding available for transfer data to a protect excel file?

  • @shahnavajkhan4770
    @shahnavajkhan4770 3 роки тому

    Jaza kalla khair bhai

  • @manickammga2344
    @manickammga2344 5 років тому

    Nice video superrrrrrbbb
    Ji .....Please upload more video we are waiting ....for your videos

  • @ranchhodkoli143
    @ranchhodkoli143 6 років тому +1

    Example :- jese ki kisi text box me 8000 MT weight type kre or usme se 5000 MT Empty Truck ka less ho jaye to niche vale text box me automatic 3000 MT show ho jaye
    Sir Apke sare Videos I very very like h ab to me apke video ke wait me rhta hu Apka trika bhut h acha h Thank sir
    Ye sir meri requst h ap ye bata dena
    Ok

  • @salmanshaikh7056
    @salmanshaikh7056 4 роки тому

    Dear Sir tons of thank you as a subscriber to teach us so much educational thing just having one query in any of the text box while typing few words automatically new lines should be added for adding another words how to do it please explain

  • @jitenderparkashkaushik6584
    @jitenderparkashkaushik6584 4 роки тому

    Kya age aur designation m filter laga saktey h

  • @mohammadilyas2240
    @mohammadilyas2240 3 роки тому

    Zabardast information

  • @darshanbhasin8720
    @darshanbhasin8720 4 роки тому

    Parvez bhai this video is very useful
    please help, Is this possible? ,
    if i search, and add or edit the data , then paste to other sheet .

  • @waqarhassan8877
    @waqarhassan8877 3 роки тому

    Hello, can we take a print of form? As a slip of expense or salary or cash recieved?

  • @dhanibuxsuhag1044
    @dhanibuxsuhag1044 5 років тому

    Sir bohot hee achi video banai h ap n thanks to u par ek sawal he agar hum is pory data ko priint karna chaen to wo kesy hoga aur ek picture ki tarah show aur us k bad print kesy karen so please ye bhi bata den thank u

  • @ShahidKhan-bb4hd
    @ShahidKhan-bb4hd 4 роки тому +1

    Daood bhai...request u to tell us how to prevent duplicate entry in this userform...plz reply asap

  • @jonamariecuribang6667
    @jonamariecuribang6667 5 років тому

    Hi Daood, please i need your help, i need a code that should be able to search data from multiple sheets and show the dat in the usefrom, i have 15 sheet in my workbook, in your code i can only search data in 1 sheet. your help is most appreciated. thank you

  • @mohammadtahir1217
    @mohammadtahir1217 5 років тому

    Very useful video Bundle of thanks. I want to search by Name not by Column Number is this possible???

  • @saraswatinegi8076
    @saraswatinegi8076 4 роки тому

    Kya isme delete ka option bhi add kr skte hn sir.

  • @mohameduddin5169
    @mohameduddin5169 6 років тому

    Sir I am thankful for your videos we learn many things from your video and we apply in our work , sir I have one request can we use sumifs formula in vba for different criteria , please reply i am waiting for your reply if possible please make a video thanks again

  • @pradeepsenapati5225
    @pradeepsenapati5225 4 роки тому

    Hi, This is really nice video but i have a query below can you please help me.
    This xlsm file always open as read-only mode. How to open in read/write mode??

  • @aliwasti6995
    @aliwasti6995 5 років тому

    Sir Very Nice Video

  • @chandrakantparmarkeshavlal5227

    bahut achha

  • @Sarvadnya2018
    @Sarvadnya2018 6 років тому

    Very nice video. how to use other butten in userform. Plz

    • @daoodcomputers
      @daoodcomputers  6 років тому

      Thanks for watching
      Watch part 1 on this video
      Link in description

  • @superahmad321
    @superahmad321 5 років тому

    awesome man
    plz tell how to colour the user form and also how to add show form button

    • @daoodcomputers
      @daoodcomputers  5 років тому

      Thanks for watching
      Part one Link in Description

  • @motivationalquoteshindi573
    @motivationalquoteshindi573 5 років тому

    Sir which book is best for learning excel advance

  • @lokilivehai
    @lokilivehai 3 роки тому

    Ek hi update button 2 sheet me kaam kar sakta hai kya aur ek hi serach button bhi 2 sheets me kaam kar sakta hai kya ?

  • @afzalsindhi2037
    @afzalsindhi2037 4 роки тому

    Make video on how to print sheet by user form

  • @BhagavadGita4
    @BhagavadGita4 5 років тому

    Superb video sir but mujhe har baat ek new form Banana he or form banne k Baad me alag se form me entry kar SKU age ki lign wise se ESA possible he kya..?

  • @gajendrakarma9228
    @gajendrakarma9228 6 років тому

    kya bat he Sir maja aagaya

  • @vishalpawar698
    @vishalpawar698 6 років тому

    Super video sir

    • @vishalpawar698
      @vishalpawar698 6 років тому

      Sir monthly by monthly data ko search kese kanre excel me VBA.CODEING HO VATOO

  • @saraswatinegi8076
    @saraswatinegi8076 4 роки тому

    Simply wow

  • @ashutoshgupta466
    @ashutoshgupta466 4 роки тому

    Print command ka bhi options ho skta hai..??

  • @mansurahmad2699
    @mansurahmad2699 5 років тому

    Thanks your tutorial sir

  • @parameshtadari9245
    @parameshtadari9245 5 років тому

    Super video bro

  • @jshprj007
    @jshprj007 5 років тому

    Sir, it's good to see the video.
    For search : can I search other entries of clients which are same two or three times.

  • @biswajitpahari6431
    @biswajitpahari6431 5 років тому

    Very nice

  • @xfreelancer5601
    @xfreelancer5601 5 років тому

    Its possible user form create a file and data are added to a another excel file?

  • @NQCUKNationalQuranClass
    @NQCUKNationalQuranClass 6 років тому

    Mr Parvez, Thank you so much for creating such an informative video which is highly appreciated. Since I have joined your channel I have learnt a lot. Please keep it up. Can I request you please let me know the command if we want to add a print button to print all database entered via form? Thank you in anticipation.
    Regards,
    Aman

    • @daoodcomputers
      @daoodcomputers  6 років тому

      watch this video print by userformua-cam.com/video/G-LHXqzbxzE/v-deo.html&lc=UgyCbP0Xv7Z1srKQdQt4AaABAg

  • @asifasif1231
    @asifasif1231 4 роки тому

    parvaiz bhai aslam o alikum...... bhai mujy ya bta dain plz agar hum koi data add kar rahy ho . us wakat time bhi add ho sakta ha kia? mtlb data add karny k duran man chahta ho k time ki bhi option ho .....?

  • @x.lpythonamicofficial7714
    @x.lpythonamicofficial7714 3 роки тому

    Thank you 💗😊

  • @sharadpanchal3589
    @sharadpanchal3589 5 років тому

    useful video

  • @kiranjariwala4611
    @kiranjariwala4611 5 років тому

    SIR your video is very useful and helpful too.
    can you share this file with me.

  • @sachindey3803
    @sachindey3803 5 років тому

    Vry nice sir

  • @lokilivehai
    @lokilivehai 3 роки тому

    Ek hi update button 2 sheet me work kar sakta hai kya ?

  • @Sarvadnya2018
    @Sarvadnya2018 5 років тому

    Very nice.
    sir delete karneka code bataye

    • @daoodcomputers
      @daoodcomputers  5 років тому

      Thanks for watching
      Ye Video dekho delete ke baare me diya hai
      ua-cam.com/video/Lq-UTNurhFc/v-deo.html

  • @ZafarIqbal-ny1xi
    @ZafarIqbal-ny1xi 2 роки тому

    sir kia hall ha main ne ak data entry user form bnaya ha as user form main mulity lines hain our jub main as ka sheet main data save karta hoon kuch line as main khali hain liken sheet ke rows main sfar safar lakha a jata ha main chahta hoon ke agar as main ek spcific textbox khali ho to data sheet main who line skip ho jaya

  • @Balwan_Singh
    @Balwan_Singh 5 років тому +1

    First off all thanks for teaching something new and interesting things in excel sheet. UPDATE function is not working. Given all the commands but all in vain. Pls advise.

  • @fcchaptar3122
    @fcchaptar3122 5 років тому

    Hi
    Bhai mujhy pochna ya hy kia userform main possible hy k koi ak specific column jo month change honay k sath khud hi apna data next column main add kar dy

    • @fcchaptar3122
      @fcchaptar3122 5 років тому

      And if possible to ap ka whatsapp number mil jai

  • @GaganSingh-ld6de
    @GaganSingh-ld6de 6 років тому

    Hello pavesh I have to create this coding in vba your last video to explain search coding only for. S.no row but we want search any item no any row or column please help us

  • @itsme_sachin
    @itsme_sachin 4 роки тому

    Thanks for the video...I have successfully created the database.
    However, I wanted to that how can I automate the Serial no. As well!!?

  • @vickyyagami
    @vickyyagami 4 роки тому

    HELLO Daood computers. I changed the search box with a username. I wanted to search with minimum character what will be the code for search box. For example, column 12 has the name Daood khan, I wanted to type dao and click search in order to get the result.

  • @nasirtechinformation4914
    @nasirtechinformation4914 3 роки тому

    Aoa sir
    Sir mera paper sheet ka kaam hai aur mein chahta houn k meri sheets k lye ik vba tyar krein jis sheets jama aur minis hoti houn ?
    Masln ,
    1000 sheet _350 aur baqi kitni hain show me in details ?

  • @mastertech1791
    @mastertech1791 5 років тому

    Very nyc

  • @sankardasgupta3170
    @sankardasgupta3170 3 роки тому

    Your tutorial is good . but your sound is very poor . Pl upgrade.

  • @manoxavier8531
    @manoxavier8531 Рік тому

    super report box set Take report using Microsoft excel visual basic pls

  • @raj24news
    @raj24news 4 роки тому

    i want your help how can i auto enter Date in Textbox (Today Day ) if i open form on 25-06-2020 then automatic date textbox show 25-06-2020 please help me...

  • @dba88bn55
    @dba88bn55 5 років тому

    Sir pse make video about How to type multi lines in textbox if entry of lengthy data as soon as possible

  • @akasharyan5349
    @akasharyan5349 4 роки тому +1

    Sir es me password protected kar sakte hai kya