Multi User Data Entry Form in Excel VBA (Part-1)

#DataEntryForm#VBAForm
Hello Friends,
In this video, you will learn how to create VBA application (Rent Management System) with MS Access database using ADODB connectivity. We have used VBA user form with Textboxes, List box, Combo box and Command buttons. We have created minimize and maximize button to work on the excel while application is running. Filter by and Order by feature has been given to navigate the data. We have used the Calendar to fill the dates.

Part 2:

Please download the practice file from below given link:

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

************* Suggested Books *********

************* My Stuff ****************

[BertandRussell]

Hats Off to PK Sir...Brilliant and Excellent work...

[ErknDrn]

You are an amazing human being. Greetings from Turkey

[Bindhyeshful]

Good initiative ..to make us understand about connectivity and their application .. Thank you

[mohdridzuanramli]

Nice tutorial sir..May God granted you with everlasting rewards and goodness.

[ikhtiyaralam]

sir, this is so very useful. sir iss main print out wali option bi bana lo

[ArmanKhan-iqji]

Hello sir u have told me y will make a report on stock management kindly make a video for automobile industry.

[mybanana]

This is hugely helpful! Do you know if this would work for other users that don't have Microsoft Access installed?

[umerkayani]

Thank you so much Sir
May Allah bless you
But sir if I creat in my PC n then I want to transfer into another PC as a whole with vba...how vl i do in easy way... I mean like a whole programing software with pasward

[michaelbernstein]

Do you have an example video or insructions of how to have mutliple users at different locations update excel workbook (sheet) in onedrive account using there local copies of excel forms (vba)?

[Viking]

Love your skills using and teaching Excel PK... Just wondering if a relational database has any advantage when using Excel as the front end? Regards... VikingLEIF

[shashikantbinhan]

Can multiple user update data simultaneously when accessing it from the shared drive?

[wnxbha]

hello! it was great tutorial. thank you, I have one question, how we want to delete those image on the button?

[jacylife]

Before we write our VBA, what do we need to prepare for?

[awalsajan]

Sir, how can i add scan from feeder command so that i can add any scanned documents into that record. Please reply with video. Thank you.

[lol]

sir hum excel fileko executable file mai change karke usme alag alag product key kaise use kar sakte hai aur usko ek professional software jaisa kaise banaye

[ranjishiyama]

is it not possible to do an update an existing record for corrections or changes via vba form to msAccess database?

[vaibhavrishi]

Good Informative... need your help if you can help on Multiple Entry record with single user in VBA user form.

[gameland]

For update button, i have already some data, i need to add new fields to it. How can I do that? Because this way shown in the video, a new row will appear

[Sebastien_Frederic]

Hi PK, thank you very much for those great work!
Can you please share with me a folder with some image, or share with me a website! Thanks

[safeerahmed]

Sir how to contact you and is it possible to make an excel workbook work as database instead of ms access and make the user form with same features