Data Entry Application in Excel VBA - Part 2
#ExcelVBA #DataEntryform
Hello Friends,
In this video, you will learn how to create Data Entry Application with List box in Excel VBA. Data is saved in the same Excel file on Database worksheet. You can Add, Update and Delete the data.
Data Entry Application in Excel VBA - Part 1
• Data Entry Application...
Click here to download the practice file:
www.pk-anexcelexpert.com/data...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...
Пікірлер: 151
You almost the only one who explains a lot of details about the code line in order to make beginners like us learning easily, not just copy/paste what you already know to our sheets.. thank you and cheers from Iraq.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
@peteronderwater4269
3 жыл бұрын
top video !!! is it also possible to place data on different sheets depending on a certain input?
Thankyou so much Sir I have followed your video part one and part two, I started entering data, it is much more easier to give templates to my team so that they submit template and then I upload straight into the form.
This is very clear and informative tutorial ! I would like to see a search button in the form as well may be next time. Thank you very very much for a very nice video.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Thank you, for such an informative video
Thank you very much, thank you very much, thank you very much for this great video and for this valuable informations and for this wonderful technique.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
thank you so much . very clear instruction, great job
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Thanks for this video,its totally praiseworthy
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Amazing thank you so much. Best most simple instructions
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Thanks to making this video in order to understand very simply......
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Thanks allot Sir. I am sorted.
@PKAnExcelExpert
8 ай бұрын
Most welcome
Thx. Mr. PK. Again a great Video.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
PK bhai Thank you very much..You are best 👌🏻👌🏻👌🏻🏅🏅
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Very good n thank you very much
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
It’s FANTASTIC, Thankee!
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
@sergeyzhavrid7676
3 жыл бұрын
@@PKAnExcelExpert If you look on my work (file in mail). From help (Data Entry re-worker) And use a theme for next period "conditional formatting". if you’re interested apologies for my English SORRY from my got a big, fat nerve
Hi Sir, Thank you very much for you support, your teaching is very good. Everything Step by Step. Easy to learn. I finished this project and I kindly request you to make a small project of Over Time of reqular staff report for every Quarterly not exeeding 50 hours and separte Over Time Project for Essential Staff. This will very useful for all of us please.....
Very interesting lesson i like it so and thank you so much
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
weuiii good for sample to learn thank you very much about your knowledge and sample file to learn thanks you!!!
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Thanks for your wise and nice video presentation.
@PKAnExcelExpert
Жыл бұрын
Glad it was helpful!
Thanks a lot!
@PKAnExcelExpert
4 жыл бұрын
Thanks for watching
Great videos , Pk
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Please share vba code to avoid duplicate entry in this userform.. Sir your way of explanation is really good.
thanks alot Mr Pk that was really helpful& wonderful
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
@awadhbinamro948
4 жыл бұрын
@@PKAnExcelExpert i want to add more text boxes Exp. e mail, professional should i copy the same code which was put for text box 4
@hasmukhnirmal1263
4 жыл бұрын
nice
worthy project if possible kindly add the search box to filter data
thnas you wel learn this
Excellent this topic Sir next video making add search record also this video
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback. I will definitively try to make it
Your the man 👍
@PKAnExcelExpert
3 жыл бұрын
Thanks
thank you :)
@PKAnExcelExpert
3 жыл бұрын
Welcome!
So nice sir.plz make a day book just like this. userform based
It's too gd thanks sir
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
This really help me a lot.. by the way I tried create a table in excel and design it .when I tried the it not auto populate in the table .. can you help me
superb sir 👍👍👍👍👍👍
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
i love you sir , tqvmm
Tnk pk sir this video is very usefull
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
@ashishkumarpal9795
4 жыл бұрын
Most welcome
Dear bro I am your follower and I appreciate your demonstration projects so I mead your help to upload one database using multi page user form
Hi Mr. PK. This is a great. Can you please make a part 3 for the search botton and to update the details? Thanks and more videos please.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback. I will try to make
good job
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
good work nice
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Thank you for this helpful tutorial. Followed everything to the letter. However the listbox and database are not showing values entered. What is reflected is Me.Textbox1.Value or Me.ComboBox1.Value everytime I click the Add button. How do I correct this?
Nice explain 👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Thankyou very much . What will be the code to print one entry in label form
Thank you sir. I need same with download pdf option.
I know it is cumbersome and lot of effort to come out with another youtube. But would appreciate if you can come with a "Data Entry Application in Excel VBA with text box as date format. Here in this if we put date and go to change the date format does not appear. Would highly appreciate if you can help me on this or come out with an video with a TextBox with one date format and one TextBox with numeric format and one TextBox with text format. this will give an complete picture to the user. Thanks so much for your efforts.
Instead of clng, does cvar work if my id is text and numbers for match
PLEASE MAKE A VIDEO FOR DATA ENTRY IN EXCEL TABLE.
Hello, thank you so much for the tutorial. My userform has a date entry, however, could you kindly share how to change textbox format to date ? Really Appreciate it, Thank You
@seekersworld4159
Жыл бұрын
You got the answer or you are still looking for the answer?
very nice job, is possible add the search button?
u explained everything extremely good thank u. where can i see more videos from you, thanks for your help
@PKAnExcelExpert
Жыл бұрын
Please watch below playlist: kzread.info/head/PLbDvAYjpWJ7B05kKkUEbcKMDZFDzrT2hI
@milotxh
Жыл бұрын
thanks for replay i save a question is save button same as add button . i dont see any difference.
what should i do if i want to add more text boxes
Excellente! Can you help me create a macro that copies values to a tab based on date? Example: In a record sheet we have values from January to December by date. Depending on the registration date, the macro should copy January values to January tab, February values to February tab, etc.Thanks
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback. I will definitely try to make such video very soon
Outstanding!! Excellent👍 How to save deleted data in another sheet? Please help me...
@PKAnExcelExpert
2 жыл бұрын
Will upload soon
@MuhammadShahAlam99
2 жыл бұрын
Boss, Thank you so much ❤️❤️❤️ I waiting for your valuable tutorial.
can you make a full data entry form with 'search' and 'print' functions?
Thanks, sir But, I like to show list box data with command button.
@PKAnExcelExpert
4 жыл бұрын
Ok next time
Dear Sir.. It is very Nice.. My small query regarding this. When data added listbox became refresh, listbox shows selection with last row entry.
@satishdeshpande1336
3 жыл бұрын
List box gets selected on last data rows. Pls guide me Thanks
Dear Sir thank you this application is very useful, is it possible for you to insert an excel template upload button and export button as well.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback. Yes it is possible. I will definitely try to make such video.
@baliongerewiong2194
4 жыл бұрын
Thankyou sir awaiting the tuitorial Excel vba is wonderful thanks
And how about same code but use data from another wookbook ?
Dear Mr. PK, If you click line 1 ( for exemple first or other line in result list form ) and then click Add, and then again click first line and Add and again the same.... You will see that you won't be able to prevent duplicate record. Please, can you fix it? Thank you in advance!
Do you have part 3 where I can search and update the searched data?😢
If we delete Sl no 1 how code works for automated serial no sir
dear sir , please tell me how add data filtering and transfering to this application .please tell me kindly soon
Sir ji next time video in excel vba in daliy collection and recovery report by fiance secter
Can pls tell Why Me. as Preffix before all tools
@PKAnExcelExpert
6 ай бұрын
In VBA userforms, 'Me.' is used to refer specifically to the current form and its controls, ensuring clarity in your code.
I want to learn vba help me
Under Private Sub ListBox1_DbClick_(ByVal Cancel As MsForms.ReturnBoolean) Me.ComboBox1.Value = Me.ListBox1.List(Me.ListBox1.ListIndex, 6) is highlighted as there is a bug. I have added two more rows for data entry. In addition, the header cannot capture the S/N number as well. Please help.
Thank you very much for the video, it is what I have been searching for a long time. I have a small problem. I have a textbox (say textbox2 is for date entry formatted dd/mm/yyyy), when i submit/add to database the date format change to mm/dd/yyyy (in both database and listbox), then when i double click from the listbox , the textbox2 shows a value instead of date. What I want is when i enter the date data in textbox2, i wanted the format to be dd/mm/yyyy and record into database / display at listbox with the same format dd/mm/yyyy, and recall back from listbox to textbox (when wanted to do editing/update) the date format remains dd/mm/yyyy. Hope you can post a solution for me to edit my vba code. Thanks a lot in advance.
@willman2010
4 жыл бұрын
Did you solve this? I have a solution if you still need it.
How to add a pic in userform
Sir how can i filter these data in list box Please help.
Sir, I tried making a userfor with the help of your video but i have come across a problem. Your CODE .... Selected_Row=Application.WorksheetFunction(CLng(Me.TextBox4.Value,sh.Range("A:A"), 0) does not accept. I tried a lot and it either says " Expected:) or some other problem. Please help me.
Hello , How can I add a scroll bar button? After 20 rows. It will stop showing the new data. Thank you 🙏
Sir ....it's possible to delete the row data but not the entire row....I just want to delete the entire row data except s.no.... Please....
I need help to enable two points. 1st for list box require scroll button. 2nd for list box how can i wrap one of column. Kindly help. Cant I run this as application without opening excel ???.
@PKAnExcelExpert
4 жыл бұрын
Hi Sharath, Scroll bar automatically created in the list box according to list size. You can not use this application without open excel because front coding is in excel vba. Alternatively you can create dot net application.
Hi sir, Thank you for your wonderful tutorial video...Im having problem with the delete function. Whenever I run the macro , select and delete a row, this error message keep on bugling me.. sh.Range("A" & Selected_Row).EntireRow.Delete that line is highlighted with yellow mark....can you help me find the missing code...im almost done...I just cant complete it because of that bug.
@constructioncost
3 жыл бұрын
I found the problem but I'm not totally satisfied. So the the problem is that when the worksheet is protected, the code cannot delete a row. Is there any solution for the lock cells not to receive error when the command is executed??
why mine keep telling invalid rowsource property.
Hi PK, I have followed your tutorial and its been very good. I've learned allot thank you. I have one small problem. In the Listbox1 when I follow your code my last Column does not show in the listbox form. I've got 7 Columns and the code is as follows. Sub Refresh_Data() Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("Database") Dim Last_Row As Long Last_Row = Application.WorksheetFunction.CountA(sh.Range("A:A")) With Me.ListBox1 .ColumnHeads = True .ColumnCount = 7 .ColumnWidths = "30,75,75,75,85,100,25" If Last_Row = 1 Then .RowSource = "Database!A2:F2" Else .RowSource = "Database!A2:F" & Last_Row End If End With End Sub Would you have an idea what I'm doing wrong here? I'd appreciate your help if you don't mind.
@PKAnExcelExpert
4 жыл бұрын
Please take rowsource till column "G". You have taken it till column "F"
@Barnadownire
4 жыл бұрын
@@PKAnExcelExpert PK Thank you so much that has worked.
@Barnadownire
4 жыл бұрын
PL, I am trying to create a Time sheet whereby I want to be able to input multiple lines of data at once, for instance: I divide my day up into 4 quarters and I am not allowed to book more than 2 hours of an 8 hour day against any one task. Therefore I have 4 lines of data for the same date I want to input. Is this possible?
Oh ps, I will pay for the form ok , tell me how much and how can I download this from here ?
Can u please advise, I wrote the codes and I did all same as you did but with some modifications as I'm using it as an invoice form for sales , and everything is fine but the update button doesn't work though i wrote the same codes as yours ,what could be the reason? Thanks
@PKAnExcelExpert
4 жыл бұрын
What is the error you are getting
can you tell me why there is no explanation about ColumnWidths and what its Type is. if I enter .ColumnWidths "8,15,17,30,20.9," it doesn't work.
What is code for ComboBox1?
When I Am Adding The Strings to The Form It Says Compile Member method not found
If we want to seach any data ..so how can we search ???
There is no tab for seach ...plz code for search tab
Hi, only second Row is updating, Not Row 1 and after 2nd Row
hi, i have problem when i make the database hidden i cannot start the form its gives error 1004
every time i want to Add i Face a '1004' error..what is the problem?
Search option is missing and print is missing
how to clear listbox1 pls help me
@PKAnExcelExpert
4 жыл бұрын
You can use me.listbox1.clear
@ruposhibanglatec6767
4 жыл бұрын
@@PKAnExcelExpert i was apply this code but not clear listbox
Can you build something for me, if I give you the date I have ?.. Just build an empty one so I can enter the date myself ok Friend ? Regards Ju
Make daybook software
@PKAnExcelExpert
2 жыл бұрын
will upload soon
kzread.info/dash/bejne/p4iotLmEdsbfZdo.html ক্সেল শিখুন: Microsoft Excel যোগ, বিয়োগ, গুন, ভাগ সুত্র। tutorial for beginners
Dear PK, thanks in advance to help me in following error. When I press Add Record button, excel generates run time error. "Run-time error '-2147417848 (80010108)': Method 'Value' of object 'Range' failed." If I disable refresh_data sub (to display data in listbox), it works fine.
@aamermalik6788
4 жыл бұрын
When there is a data in Listbox, it generates above error, otherwise works fine.
VBA code to auto serial number LIKE "AG0001" In textbook1
Good aftnoom this giving this error open form Runtime error '-2147352571 (8002005)': The Value property could not be set columnwidth . Non-Matching Type.
@bennyshalmy
Жыл бұрын
In your system, you have to separate the individual widths with semicolons instead of commas, for the value of columnwidths.
This really help me a lot.. by the way I tried create a table in excel and design it .when I tried the it not auto populate in the table .. can you help me