Fully Automated data entry Software in Excel - Data Entry User Form - Data Entry In Excel

Fully Automated data entry Software in Excel - Data Entry User Form - Data Entry In Excel
Dosto bina VBA ke Microsoft Excel me accha sa Data Entry Software bnaya ja sakta hai ? ab aap soch rahe honge ki bina VBA ke Data Entry Form kaise ban sakta hai ?
is video me maine btaya hai ki kaise vba ke bina hi hum excel me accha sa fully automatic and fully dynamic data entry user form bna saktey hain. ye user form online forms ki tarh kaam karega aur form ko submit kartey hi entry automatic database me save ho jayengi. agar aap excel me definitely kuch nya seekhna chahate ho to ye video jarur dekhe
in this video you will learn how to create Fully Automatic and Fully Dynamic Data Entry Software without using VBA in Microsoft Excel.
Subscribe My New Channel DEEPAK TECHWORLD bit.ly/3qFrbl5
Download Template : bit.ly/3wKuABY
Chapters
00:00 intro
03:04 Creating Data Entry Form Without VBA
20:20 Connecting Form to Database
26:04 Outro
#DataEntryForm
#Userform
#Userform_in_Excel
#Data_Entry_in_Excel
#DataEntry
#Excel_Formulas_and_Functions
#Excel
#Excel_Tips_and_Tricks
#ExcelTips
#Excel_online_course
#deepakeduworld​​
#Microsoft_Excel
#How_To
#excelvba
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld​​
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld​
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakedu​​world
Thanks for watching

[@MukeshKumar-jq4vj]

बहुत ही शानदार वीडियो बनाया है आपने बिना Excel VBA के भी इतनी शानदार वीडियो इस वीडियो के लिए आपको बहुत-बहुत धन्यवाद हमें आशा है कि हमारे लिए इतने हेल्पफुल वीडियो और बनाएंगे

[@pkmahato15]

Sach bolai hai brother 💞

[@OwaisRazaa]

@@pkmahato15 5 either 🐸5555t 🍌5 yuruyuri we rt5 hn

[@dineshjhunjhunwala7472]

Good Jai shree Ram

[@user-jm9mn3pd2k]

Aisa teacher mile to koi bhi unpad na rahe. Nicely explain sir, hats off to you

[@tyfor002]

I was like what a hell, but I was patient to watch fully automated functional excel without coding. It really worth it. Kudos guy, you tried. I just learn a powerful approach.

[@pandyachintan]

I am running a Clinic and as i cant afford a fancy software for patients data, This video made my day! I kept following every second of your vdo and made my patients data entry basic software kind of stuff ! Thank You sir 🙏🏻👍

[@radhakrishnanp3322]

Great information and excellent work. As you mentioned in the beginning no one made such a wonderful video regarding excel form without coding in youtube. I was really searching such a work since long time. May God bless you to achieve the peak of success and increase your knowledge beyond the limits so that it will be great help to the needy in future too. Thanks again 🙏🙏🙏🙏

[@ajazhassan9637]

Aameen

[@raheeleyfrsh]

bro you are really an honest teacher in this selfish world...so amazing...love from Pakistan

[@konsamprincesingh7763]

It was really a wonderful excel tutorial. Taught in such a friendly and easy way. Hats off to you brother.

[@dildokafir5058]

kzbin.info/aero/PLjOmfoUx9xOvFoscCpa6AIKl9R6IAL1kP

[@vishalbhati912]

Me sirf data transfer trick k liye dekh raha tha. Mujhe ye pata tha ki vba se karoge aap. Par ye nhi pata tha ki record macro se hi kaam ho jayega. Bahot bahot dhanyawad

[@rounakshahdeo7941]

Bhai Ye Hui baat आपने मुझे बहुत अच्छा चीज सिखाया है उसके लिए धन्यवाद❤️

[@yingkionglab8143]

Bhut sunder Deepak ji...ur r amazing Teacher....Thanks for share with everyone 👍👍👍👍👍🙏🙏🙏

[@BCCDAILYPAK]

Ya ALLAH har insan kamyab ho har insan ko sehat izat reham or karma farma meray Malik.

[@FowzaanAdilOfficial]

AMEEN YA RAB UL AALAMEEN

[@wang8171]

Ameen

[@alphonsphilomi5808]

@Fact Munde v7

[@umaraaliya151]

Aameen summa aameen

[@adiladil2261]

Ur whatsapp me from kashmir

[@khawarahmed2692]

Very Good Bhai From Pakistan Aesi hi videos bnatay rhen.👌🏿

[@06mummaandanshu]

Your way of explaining is just awesome itna toh paise deke v nai sikh sakte jitna apki video deakh k sikh lete hai . thanks bro

[@06mummaandanshu]

Hey brother i m learning dashboard from your video kal thora practice kari thi aaj v karaungi .you are such a good teacher

[@b.karmakar2538]

I appreciate your talent. Pls. make the "Save Entry" button inactive when any data is blank. ie., make a condition to stop running the macro when the "Save Entry" button is fade in colour so that no blank data be saved.

[@dipeshrawat251]

Good question... Go to macro coding and use if statement for the cell value = 6 then Else End if

[@dipeshrawat251]

Hope you have under stood..

[@punjab7158]

How we can save micro work in excel ? I try to save sheet but it’s didn’t work after saving .

[@parrysk]

@@punjab7158 CHOOSE MACRO ENABLED WORKBOOK IN "FILE TYPE" AND THEN SAVE

[@lakshminarayananc.g.8267]

​@@punjab7158 Save it as .xlsm file

[@muhammadyounis2686]

Although I am also fluent in Excel but this tutorial was "Zara Hat kay"🙏 Love from 🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰

[@aheshkharat692]

Excellent video sir 🙏🙏 I would like to appriciate your knowledge.i learnt excel from your videos.lot of thx for sharing your great knowledge 👍👍

[@iknow3335]

I did not understand a word from you except Ctrl C Ctrol V etc, but I have learnt this staff from your.video Thank you so much.

[@mussawarhussain]

Excellent brother, one question, Can we picture with same type of working.?

[@educationhelper6620]

thank you so much sir for this effort. i also appreciated your talent

[@jsolve4573]

Hello

[@GaneshKumar-do7lo]

formula kya hai bhai pata nahi chal raha hai comment me batana

[@muraly3523]

@@GaneshKumar-do7lo I have posted a video. Will be useful kzbin.info/www/bejne/n4SvYmx9nqySibc

[@vinaymishra8108]

दीपक जी 🙏 निश्चय ही Excel बहुत से लोगों को आता होगा लेकिन पढ़ाया कैसे जाए या सिखाया कैसे जाय, ये भी एक कला है। और आप इस कला के माहिर शिल्पकार हैं। बहुत-बहुत शुभकामनाएँ ।

[@DeepakEduWorld]

Thanks vinay g 🙏

[@d.v.shettyclasses9765]

Not only this video, all your videos are just great. Thanks and hats off to you for your efforts 👏

[@ZARINSTITUTE]

Ya ALLAH har insan kamyab ho har insan ko Izat or Sehat ata farma.

[@avezkazi7673]

Amin Bhai

[@mdfaizanalamansari5115]

Masha Allah ❤️

[@muraly3523]

@Ganesh Kumar I have posted a video. Will be useful kzbin.info/www/bejne/n4SvYmx9nqySibc

[@malikafanhameed2740]

Thank you bro. Your way of teaching is simple & easy.

[@sureshbangar6347]

एकदम खूबसूरत डेटा एन्ट्री आपको सलाम 👌👌👌

[@Ahmedkingvlogs1234]

If I have three options instead of two,(Good,Batter,Best) then how can the formula be applied?

[@One_Of_Kind_Jilu]

9:55 developer tab 16:00 button 22:00 macro recorder

[@mudassirmaqsood7715]

Learned a lot from this video.... Thanks for making a true and helpful for learners

[@NMPSONGS]

Just awesome 👌👌👌 Fantastic Creation, easy to understand and smooth learning. Thank you so much.

[@yogeshkole6800]

SIR PLZ MAKE A VIDEO ON STONE CRUSHER SOFTWARE OF INVENTORY, BILL, LEADGER OF ALL PARTY

[@CartoonCLIP2]

Lets begin the ttttttttooooopic...

[@iamthatakashkaushal]

Bahut achha video banaya Deepak Bhai, Thank you!

[@brsdream]

Very useful and creative video and that too without "vba". I want to add photos of each person, i.e., like id cards in this form. (many of us would be waiting for the same).....pls make the video...we all would be very grateful....Keep up the good work. Best wishes.

[@mmaheshkumar3582]

Actually i need macro recording part but watched completely without forwarding. Tq very much

[@jyotirani8232]

Macro record kar ke to koi bhi kar lega, actual VBA code ke sath batao sir. ye sab to pahle se pata tha.

[@aakash26as]

Aap kuch naya bta do please maam

[@mussawarhussain]

App k mohelay main jo dukandar hay osay kehna ker k dikhaey, very funny. Miss this one for those people who don't know programming. Otherwise there are dozen of languages better than VBA. appreciate the simple working rather than criticism.

[@vishaljaiswal203]

Mam ye Excel hai is video me VBA ki coading nahi sikhayi ja rahi hai...

[@jyotirani8232]

@@vishaljaiswal203 pata hona chahiye, VBA excel ke liye he hai, koi alag nhi hai.

[@jyotirani8232]

@@mussawarhussain waise to aap rikshe wale se monday ya tuesday ki spelling bhi puchoge to nhi bata payega. koi bhi ka mera matlab tha jo log is field me hai.

[@enigma8627]

कमाल की वा वीडियो बनाई है आपने, आप सदा सेहतमंद रहें और सुखी रहें।

[@zahidmaqbool19]

Really loved the technique to insert a row instead of scrolling down to the end of the list.

[@Priyajmalvi2000]

It's really good to know the use of excel like this ...this is very Inspirational video ..nd I like this 😊

[@roshanicomputerwaghai4688]

बहुत ही शानदार वीडियो बनाया है आपने बिना Excel VBA के भी इतनी शानदार वीडियो इस वीडियो के लिए आपको बहुत-बहुत धन्यवाद हमें आशा है कि हमारे लिए इतने हेल्पफुल वीडियो और बनाएंगे Thank you.... 🙏🙏🙏🙏 3

[@csstudent7689]

Best work done from your side. I Appreciate your hardwork thats free to us. Love from pakistan

[@nareshkaliramna883]

Bahut hi sandar video bnai h aapne 🙏🙏🙏🙏thanku 🙏🙏🙏

[@manishkalyan-ig3ix]

Sir ye to super se uper hai, bas ek chij ki dikkat hai agar next entry neche vale row mein add hoti toh kamaal ho jata, apka ye vedio dekh kar boat kuchh sikha jo pehle socha hi nai tha. Like formatting ka itna axhha use, fir vo micro ka use kamaal kar diya sir.

[@SaddamKhan-gm2uz]

Hello deepak,your videos are really helpfull , i really appreciate your efforts.i made a invoicing system in google sheets , now i will incorporate this too into my invoicing system to convert the data automatically to a ledger. Thanks

[@yagneshjoshi6597]

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

[@miteshdd]

Excellent video for learning a simple data entry form which can be used by any basic user!

[@abhisheksugandhi9446]

Bahut aasan ho gya mera kaam Deepak sir 👍 thank you sir

[@jspanner]

That way you showed is awesome... Its easy to implement and pretty helpful... Thanks man...

[@g.m.mughal7278]

اچھا لگا 👍

[@hadiakbarkargili637]

Great respected teacher, You are master of Excel Sir, keep upload such type of important lectures of Excel, waiting for your next lecture, accept my love 💕 from Pakistan.

[@lemonsoda9879]

Dum hai sir.... Jo VB se nahi seekh ppaya.. Aaj iss se sikha

[@abhisheksugandhi9446]

Deepak sir bahut achha he mera kaam aasan ho gya bahut

[@icebox9203]

Very good video. Thanks for the same. I always thought these things are very difficult. But you have made it so simple. 💙💙💙💙👌👌👌👌👍👍👍👍👍👍

[@kapilnawale6884]

आप व्हिडीओ बहोत अच्छी तरिके से और आसान भाषा में जानकारी देते है बहोत बहोत शुक्रिया...

[@kanchanrani4873]

आप बहुत अच्छा समझते हैं

[@aamirkhan856]

This is amazing brother your are legend man of MS Office in Excel. ❤️❤️❤️🎉🎉🎉💐💐💐

[@ajazpathan7899]

Thanks sir aapke knowledge se mujhe bahot fayda ho raha hai🙏🏻🙏🏻💐

[@adhyanaturals7456]

Thank You So Much For Sharing Your Excel Knowledge In A Very Simple And Easy To Understand Way.

[@paishlufz]

Very Well Deepak I appriciate your effort & work you have done areally really good job & put a deep knoweldge about Ms excel in our minds. Keep it up

[@ghufranaa]

Great Job Deepak 👍 Respect 🌹from Pakistan 🇵🇰

[@inayatrehaman9988]

Masha Allah... Bhai Jan Kamal kar dia.. bohut Dino Kay bad KZbin say kuch acha seeknay ko Mila... Etna Khushi huwa kah kardia like our subscribe.. Inayat Ur Rahman from Pakistan

[@muhammadzeeshan9089]

Deepak boht zabardast, me ne boht seekha hy aap se.. Thank you

[@DeepakEduWorld]

🤗

[@amitdas2025]

sir, you are soo helpfull.... one of the best youtuber ...... thsnks ......for your teaching......

[@amitdas2025]

Thank you...

[@vaibhavgupta6337]

Bhaii bhot kaam ayi aapki video haal hi me Maine ye class li thi aur mujhe kuchh khaas smjh me nii ayii thii but aapki ye video dekh ke merii sari confusion door ho gyii so thank u so much

[@mdazharhussain3868]

Superb . Apne bahut acha kaam Kiya h .mujhe ye vedio bahut achi lagi .mujhe bahut help hui

[@harichandranathPatel]

bahut hi jordar jankari di aapne aaisa to ms office coaching wale nahi batate

[@sr_sujeet]

Sir hum aapke fan ho gaye hai kasam se aapki video gazab ki hoti hai ❤️❤️❤️❤️❤️

[@ashish1584]

wah absolutely fantastic video. bohot badhiya bhai

[@shripadkulkarni8072]

Thank you Dipak... 🙏 I was searching for this type of technique in excel from long time...

[@kishorenaidu7985]

Brother.... It was really work.... And very impressed with your teaching method and get great knowledge from you

[@rohitpareek4475]

बहुत ही अच्छा video है। अब कुछ काम भी बता दीजिए भाई।

[@majidaliawan72]

You made my day, very informative vlog.

[@d.v.shettyclasses9765]

best excel tutor 👍💯💯💯

[@Isaiah9.6]

You're the BEST!! Hat's off to your expertise!! Just superb!!

[@vinayak4898]

Sir dil se bhot mahant ki aapne or bhot shandarr or easy way may samjhaya hai thank you so much 💜

[@shankariyer62]

Zabardast..just the one I required...thank you brother..dhanyawaad...this is ekdum magic

[@bashiruddinsiddiqui4420]

Deepak sahib ap boht achi trah define kerty hn mujhy ap sey bhot kuch sekhny ko mila hy allah ap ko khush rekhy

[@harisaliafsar7613]

Very nice... To the point... Excellent way to describe the process. 👍🏼

[@aravindakshanarvind2442]

Most useful vba lesson with excellent narration

[@janithaheem7107]

MashaALLAH. Rab e Kareem Ap k ilam men aur izafa Kare. Ameen MashaALLAH Zabardast. Ap ne Kam asan kar deya h

[@lewany1079]

Amazing video sir g aj tak main ne eisa data base form nahi deka never ...love u sir good luck and good wishes

[@ramnareshnut9997]

Hello Sir aap bhut Achaa video banate ho bilkul achha se samjhne me aa jata hai

[@mohdnadeem5811]

Really very much smart and Amazing Really sir i appreciate your struggle nice complimentable work

[@babajhawan975]

22:00 Your Way Of Teaching Is Amazing

[@ranjit0307]

Bahut achha knowledge Diya h Apne. Salute sir

[@PriyankaSingh-cv1cv]

Sir, today I have seen your this video... Really Appreciated.... Excellent sir... It helps me so much.... Your way of explaining and teaching is very good..... Thanks for this video sir✌✌✌✌✌✌✌

[@DaryawSinghShekhawat]

बहुत ही शानदार वीडियो बनाया है ,इस वीडियो के लिए आपको बहुत-बहुत धन्यवाद !!

[@creativepralay5901]

Excellent sir, huge respect. Is it possible to save entry in ascending order?

[@futureplan2223]

Bahut acha laga, detail me bataya apne..thnk you..

[@rajeshshirwadkar6265]

Nice video and effective teaching. Thank you

[@crazyentertainment9531]

Boss Great video 👍👍👍 kuch naya sikhne ko mila...

[@MushtaqQureshi]

excellent lesson. it's worth time spent.

[@vishwanathhaldar3954]

Enjoyed New Cell Data Entry Metric Is Very Fantastic

[@manishdixit7293]

Bhut badiya video banaya hai sir aapne..

[@ziagi0076]

It’s really amazing Brother. Thanks a lot.🥰💕 I found you today and I tried it. 💕

[@dhushanic8844]

Thank you so much for ur video It's really very useful I like this channel From Sri Lanka

[@prashantgupta8804]

This is very nice and informative. Just a question - since macros don't work on Web excel, is there a workaround for that too?

[@udaynaththakare7547]

मुझे इस तरहि फॉर्म चाहिए था, धन्यवाद दिपकजी

[@sushantpradhan910]

Perfectly done..great work

[@alokchaudhary3400]

Bahut badhia

[@usmananwar6537]

Dear Deepak ! Great work indeed. Really very helpful for all. Love from Pakistan 🇵🇰

[@pspk70]

Hi Deepak ji. Very clever use of functions and features in Excel. Superb !