Dark

Fully Automated Data Entry User Form in Excel - Step By Step Tutorial

TheDataLabs
Subscribe
Views 565 961
97% 5 517 143

Simple, Dynamic and Fully Automated Form in Excel - Step by Step Tutorial
In this video, we will learn how to create a fully automated Data Entry Form in Excel with List Box Control as a database. Here, we will utilise Text Box, Option Button, Combo box, List Box, Command Button and Frame to develop this automated form.
If you don't know the VBA or Macro then there is no need to worry. This tutorial is a Step by Step guide and with the help of this tutorial, you will be able to develop a fully automated data entry form and learn several VBA tips and coding.
#DataEntryForm #TheDataLabs
Please follow the below link to download the Excel file used in this video.
thedatalabs.org/fully-automated-data-entry-form/
Please visit our website for learn more about Excel, Power BI, VBA and Visualization.
www.thedatalabs.org
Please contact us on info@thedatalabs.org

Thanks for watching!
Please like, share, comment and subscribe.
Have a great day!

Published on

 

Nov 16, 2019

Share:

Link:

Download:

Loading link...

Add to:

My playlist
Watch later
Comments 80
TheDataLabs
TheDataLabs 4 months ago
Please watch the Complete Tutorials (Part 1, 2, 3,4 and 5) of creating Fully Automated Data Entry Form in Excel. Part 1 (UI Design, Transfer and Reset) - ruvid.net/video/video-P53T6oxgUVA.html Part 2 (Edit and Delete) - ruvid.net/video/video-K1d4JpuLkqE.html Part 3 (Search and Filter) - ruvid.net/video/video-BdEMj4NNXAE.html Part 4 (Validate and Print) -ruvid.net/video/video-0bFOKpaSIBg.html Part 5 (Full Screen, Zoom and Dynamic Drop-down) - ruvid.net/video/video-f7W3HRLQYAs.html
Hima Joshi
Hima Joshi 4 days ago
Pl let me know when you will add multiuser feature in this data entry form. Really appreciate your work.thanks in advance
Hima Joshi
Hima Joshi 4 days ago
Pl add multiuser feature in this userform. Request you to add multiuser feature in this data entry form. I love your work. God bless you
kapau nkelo
kapau nkelo 15 days ago
@Ernest John Suca This is the same issue, am experiencing..Did you find the solution ?
Lynn Turner Maloney
@Ernest John Suca Same issue here- did you find the fix?
Dhaval Daraji
Dhaval Daraji 21 day ago
I am unable to give "tab index " to list box. It is remained " 0 " only. Please tell me why this is occure ?
Narendra Thapa
Narendra Thapa 24 minutes ago
Great video sir, can we make it online as google sheet?
FlirtyStylo
FlirtyStylo 5 hours ago
My computer time is 02/06/2020 2nd June 2020 but after submitting file date shows 06/02/2020 2nd February 2020... Please tell me
TheDataLabs
TheDataLabs 27 minutes ago
Please use format function to transfer the code to excel sheet.
supamomo91
supamomo91 8 hours ago
First of all, this is an amazing userform! I have a question. I re-created this userform however, the some of the columns in my database are not empty and it has formulas. These formulas will give me a result depending on value input in other columns. Example: Column 1 is blank, Column 2 has a formula, Column 3 is blank and Column 4 has a formula and these formulas will give a result depending on the value input in Columns 1 & 3. Is there a way to code the userform to only input values in certain columns? I believe the iRow statement in your Userform only deals with empty rows and in my case there are no empty rows due to formulas. I would really appreciate your help, thank you!
Sujay Goswami
Sujay Goswami 23 hours ago
Very amazing art work Dilip.. great skill..
SnipeActive
SnipeActive Day ago
Very helpfull...can u please add search and when we search anly the person or id we serch will be daiplay...can you do that please
TheDataLabs
TheDataLabs Day ago
Please watch the next four parts of this tutorial. Have already convered these features. Thanks!
Julianne Hinojosa
Hello, I am having trouble right at the end. After setting the buttons, I Debug and get message “Compile Error: Sub or Function not defined.” In the section for Private Sub cmdSave_Click(), the highlighted issue is “Call Submit.” Please advise. Thank you!
Julianne Hinojosa
TheDataLabs How do I check the Submit Function in the module? I have no experience with this.
TheDataLabs
TheDataLabs 3 days ago
Please check the Submit function available in module.
Ravi Kumar Koppula
Hi thanks for these nice tutorials. do you have similar kind of tutorials where form data is loaded into excel tables instead of data range?
TheDataLabs
TheDataLabs 6 days ago
Thanks for your feedback! Will post a tutorial on that.
Ahia Quial
Ahia Quial 7 days ago
Pls make tutorial on how to edit and delete thanks
TheDataLabs
TheDataLabs 7 days ago
Please watch the next parts of the tutorial. Have already covered all the features. Thanks!
BDMD CLUSTER-B MISAMIS ORIENTAL
Hello TheDataLabs, just want to ask how to make it in uppercase of values of employee name in the lstDatabase? Hoping for your immediate response. thanks.
TheDataLabs
TheDataLabs 11 days ago
Please use while transferring the name to database.
BDMD CLUSTER-B MISAMIS ORIENTAL
@TheDataLabs where could i insert the code??
TheDataLabs
TheDataLabs 11 days ago
You can use Ucase VBA function. E.g. VBA.Ucase(txtEmpName.text)
tuhafeni mwandingi
tuhafeni mwandingi 11 days ago
Hi Mr Kumar, kindly help. My userform ran in an error upon login in, it show the password is correct but upon click okay it cannot go further and i disabled closing of the userform. Is there any way I can debug or anything i can do to access VBA to edit the code that caused an error?
tuhafeni mwandingi
tuhafeni mwandingi 10 days ago
@TheDataLabs Thank you very much. Do i need to do this as the file loads and it is CNTRL + B or? Because i am not sure if I understand. or is there a way to remove protection for structure without opening the file because the file is stuck at login and i disabled closing the login userform with querryclose code.
TheDataLabs
TheDataLabs 11 days ago
Please don't enable the macro and then visit to VBA window to access the code. Alternatively, you can press CTRL + Break to stop the code and jump to VBA
tuhafeni mwandingi
tuhafeni mwandingi 11 days ago
@TheDataLabs Thank you for the the timeous response. The thing is i cannot access the codes because the form is stuck at login and giving me error 400. I am sure it is conflicting with hiding sheets when the workbook structure is protected because that's what i was trying to work on. If there is a way to get to vba editor to access the codes so that i can fix them. Thank you.
TheDataLabs
TheDataLabs 11 days ago
Please check the code available in Workbook Open and Form Initialization Events. Thanks!
Nancy Habisreitinger
Dilip I am having trouble getting the save and reset to work, if I send you all my coding, could you please look it over for me. I really like the way you go into detail. This is my very first time Ian coding in vba. I would really appreciate your assistance. Thanks Nancy
Nancy Habisreitinger
@TheDataLabs How do I send you an attachment through youtube?
TheDataLabs
TheDataLabs 11 days ago
Thanks for your feedback! Please share the Excel file.
saravanan kumaravel
Hi Thedatalabs, I'm facing error on .lstDatabase. while doing debug, help to sort out the issue
Medical Officer HIMU
Hi, im getting an error with this iRow = [Counta(datasheet!A:A)] + 1
TheDataLabs
TheDataLabs 13 days ago
Please share the error message.
Guru Raghavendran
Guru Raghavendran 14 days ago
Thank you sir.. Kindly make how to conduct online test using excel or simple way. timing and control should be with us. guide me.
TheDataLabs
TheDataLabs 14 days ago
You can use Google or Microsoft Form for that. It will be easy without coding. Thanks!
Muhammad Ramzan
Muhammad Ramzan 14 days ago
Sir few month ago u described to installation of corel draw x9 in a you tube video , I tried to find this video again but fail
Vinu Sharma
Vinu Sharma 15 days ago
Sir .listDatabase.ColumnCount=9 में error aa raha hai
kateregga john
kateregga john 16 days ago
Good I need to learn more. I want to use it to create ledgers.
Shivam Harnal
Shivam Harnal 16 days ago
Hey, please help me with the issue that I have mentioned in the previous comment. I have also replied you with the link, please help...🙏
Ravinder Sharma
Ravinder Sharma 16 days ago
Can i display data with some condition from master file
Karina Pascua
Karina Pascua 17 days ago
Thank you so much! This is a great help! I totally love it! IT TOTALLY WORKS!
Nico Mahinthan
Nico Mahinthan 17 days ago
how to total the sum in the row and how to display ?
TheDataLabs
TheDataLabs 17 days ago
You can use evaluate function here. Suppose we need to sum the data available in range A2:A10 from Sheets and display it to Textbox1 then code would be Textbox1.value=[Sum('Sheet1'!A2:A10)]
Chia Hoo Hee
Chia Hoo Hee 17 days ago
Please accept my highest compliment to you, your VBA video had give me so much of aspiration for my work process improvement! Sir, i need your helps look into my issue in your Tutorials for validating Duplicate Entries on Employee ID column. I have managed to run the validation function with ur given code on Employee ID field. Unfortunately, when i try to use edit button to change data in existing record database, it remains to prompt out the duplicate msg box, can you helps to check how can we revise the coding to avoid this duplicate msg when i want to edit existing data?
luchtridder
luchtridder 18 days ago
Great tutorial, thank you so much. I like to add a tax calculation data into my form. Can you help me with that please? It is for my bookkeeping. as an example. i made 50 euro for my services and need to add goverment taxes of 0% or 9% or 21% (Dutch taxes). This also goes for expenses . Like i bought something and need to be able to add those same goverment taxes. It would be amazing if you could help me with that. Greetings from Amsterdam
Praveen Kumar
Praveen Kumar 18 days ago
how do i add specified column to list box?. means i dont want to show all 9 columns
Juan Antonio
Juan Antonio 18 days ago
Great step by step tutorial! you're very patient to explain each step. It's so clear. Regards from Mexico!
TheDataLabs
TheDataLabs 18 days ago
Thanks for your feedback!
er yel
er yel 19 days ago
Great, it works! Thanks.
isaias alarcon
isaias alarcon 19 days ago
Can you help me to create an Excel sheet for food waste? that has a PLU#, NAME OF THE SALAD THE PRICES, The Quantity, the Total. also, Need to know if it from (Kitchen, Deli, Cheese, Bakery) And wich store it comes from (1,2,3,) for example.. 1) PLU (100) Potato Salad 2 LB. @ $5.99 lb = $11.98 FROM KITCHEN STORE #1
Koen Decuyper
Koen Decuyper 20 days ago
I would like to add a STOP button to my form, which closes the form and goes back to the Home sheet in which my command button is located to go back to the form. How can I do this?
TheDataLabs
TheDataLabs 20 days ago
Please create a Stop Button on Form and then double click on that Button to write the code on click event. Suppose button name is cmdStop then code to close the form and visit to home sheet would be as mentioned below. Private Sub cmdStop_Click() Unload Me 'to close the form Sheets("Home").Activate End Sub
Koen Decuyper
Koen Decuyper 20 days ago
When programming the VBA code, everything is working fine for me, except that in the form list below, I only see one row as a result => the one from my first input. When doing a second input in the form, it is not showing as a second row in the listbox. Despite that fact, my database is working correctly. All records are showing. What do I need to adjust in my listbox , so also there it shows different rows when entering multiple records
Koen Decuyper
Koen Decuyper 19 days ago
Is ok now. I did not know where to change the columnheads in true. So, now i did in vba code and it is working right now.
Koen Decuyper
Koen Decuyper 19 days ago
@TheDataLabs colomnheads is set on true. Under rowsource i would like to refer to the sheet "database" to cell a1 up till ag1. That is where my headers of each column are. Can you share screenshot how it should look like. I would be very grateful
TheDataLabs
TheDataLabs 20 days ago
Please make sure you have set the ColumnHeads property of Listbox as True. Also, you are not selecting the header reference while assigning range to RowSource property of Listbox. Thanks!
Koen Decuyper
Koen Decuyper 20 days ago
Now it is ok... I see all records appearing. But I still do not see the headers of my database. How do I manage that?
TheDataLabs
TheDataLabs 20 days ago
Please check the reference while assigning the range to list box. I believe the dynamic row number used in that reference always returns row number 2. Thanks!
Ningtoulung Gangmei
The explanation is not at all clear, especially when you start entering the functions
TheDataLabs
TheDataLabs 21 day ago
Thanks for your feedback! Will take care in upcoming tutorials.
Din PD
Din PD 22 days ago
Excuse me, i followed your tutor but why on my work is a failure😔 it’s always say “type mismatch” or something like “break mode”😔
TheDataLabs
TheDataLabs 22 days ago
Please share the line of code where you are getting error. Also, download the sample file from description box and match your code with that. Thanks
Ms Masey
Ms Masey 22 days ago
Woowwwww THank you so so much!!!
TheDataLabs
TheDataLabs 22 days ago
Thanks for your feedback! I would request you to watch the next 4 part of this tutorial to learn Search,Edit, Delete, Print and other features. Thanks!
Saumil Shah
Saumil Shah 22 days ago
I created a file using your instructions in this video. However, I want to share the file I created with other users.. want the file to be edited by multiple user at once. How do I do it?
TheDataLabs
TheDataLabs 22 days ago
There is a separate tutorial on Multi user data entry form. Would request you to watch. You will find useful. Thanks!
Premkumar G
Premkumar G 23 days ago
Please confirm If multiple users use this file at same time
TheDataLabs
TheDataLabs 23 days ago
It can be used after making some changes in Code and Keeping the database separately. I have uploaded couple of tutorials on Multi-user Data Entry form. You will find those tutorials helpful. Thanks!
Manish Kashyap
Manish Kashyap 23 days ago
thank you for this one request please speak little slow
TheDataLabs
TheDataLabs 23 days ago
Thanks for your feedback!
Manan Dave
Manan Dave 23 days ago
Hii Can you tell how to add multilevel sub totals using vba ?
Robert Morin
Robert Morin 23 days ago
This is a great video and I've already completed #2 and am working today on #3. Question: is it possible to have the lines of the database show in the box at the bottom of the form when the form opens? Without that, a record has to be created and saved before the records become visible. Unless I'm missing something, if I just want to edit a record I can't just select a row.... I have to hit 'save' to create an empty record so the rows of data become visible, then do my edit, then 'delete' the empty record. Thanks for the great work!
reddy NAGA
reddy NAGA 24 days ago
hi bro i was doing same coding but its not working for me
TheDataLabs
TheDataLabs 24 days ago
Please download the Excel file from the link provided in description box and run the file. Thanks!
Mohamed Mubeen
Mohamed Mubeen 24 days ago
U did very hard work. All codings are preplaned that means u are expert inthe relevent. Wishing more important updates all the very best
TheDataLabs
TheDataLabs 24 days ago
Thanks for your feedback!
Shreya Purohit
Shreya Purohit 25 days ago
at 23:47 i'm unable to compile the code at debug menu. its showing ".value" is not a member of the data . i have even tried to run ur description code but still same. pls help!
Shreya Purohit
Shreya Purohit 22 days ago
@TheDataLabs sir i had written the exact code as of you... After that even i downloaded your excel file and tried to compile it , it showed the same for: txtID.Value txtName.Value
TheDataLabs
TheDataLabs 22 days ago
Could you please share the 'With' statement as well? Thanks!
Jikku
Jikku 26 days ago
Hi Can we create multiple forms in same excel file?
Jikku
Jikku 26 days ago
@TheDataLabs Could you please brief me on this.
TheDataLabs
TheDataLabs 26 days ago
Yes
Daniel Karsten
Daniel Karsten 26 days ago
Hi there thanks for this great tutorial, I would like to reference the cmd box to an existing database with field to choose from how would I go about doing so?
TheDataLabs
TheDataLabs 25 days ago
Thanks for your feedback! Are you looking for transferring the data from form to a Database sheet on condition (having multiple database)?
Pravin Satbhai
Pravin Satbhai 27 days ago
I have added six frame into the form ,i am trying toi give the TabIndex order to all the text boxes; but the tab index numbers are changing automaticaly, please help to get out of this.
TheDataLabs
TheDataLabs 27 days ago
Frame is basically to group similar type of objects or a particular section in a form. Tab Index starts with 0 in every fame. Please start start with 1 or zero if if you are moving from one frame to another. Thanks!
Sabari Nagarajan
Sabari Nagarajan 27 days ago
It worka great but reset is not functioning properly
TheDataLabs
TheDataLabs 22 days ago
What is the error message? Please share the line of code where you are getting error. Thanks!
Benjamin Chilton
Benjamin Chilton 27 days ago
I have tried to follow this exactly but keep getting an error on frmform.Show!! Any suggestions? Any help would be greatly appreciated
Benjamin Chilton
Benjamin Chilton 27 days ago
TheDataLabs thank you for your response. I will look into it.
TheDataLabs
TheDataLabs 27 days ago
There may be some error in code and that's why it showing at the time of loading form. I would suggest you to download the file from the link provided in description box and match your code with that. Thanks!
PUSHPENDRA PANDEY
PUSHPENDRA PANDEY 28 days ago
not able to type in txt box
TheDataLabs
TheDataLabs 25 days ago
Please check whether it is locked or not.
Snehal Deshpande
Snehal Deshpande 28 days ago
Hi... I am getting runtime error 13 on userform.show. What might have gone wrong??
Soukdeth Phone
Soukdeth Phone 28 days ago
Thank you for this video
o o
o o 29 days ago
this will help me with my work so much. thank you data labs bhai!
Nawark Pande
Nawark Pande 29 days ago
Thanks for the video, if i have 4 options instead of 2, what should be used instead of "iif" command for save command
Nawark Pande
Nawark Pande 29 days ago
@TheDataLabs thanks for your reply, however it is not working i will post my code tomorrow
TheDataLabs
TheDataLabs 29 days ago
Please use If and Else If for that. Thanks!
Naresh Penumetcha
Naresh Penumetcha 29 days ago
Thank you. It is very useful. This video summarized all my learning of two weeks. --> It is creating a row in database if the screen is saved without data... except gender, User Name and Time. How to control it? I do not know how to make data input fields mandatory . Please guide me
TheDataLabs
TheDataLabs 29 days ago
Thanks for your feedback! Please watch the complete series of this tutorial. Have already covered validation, search, edit, delete, print and other features. Thanks!
Divyanshu shrivastava
aap excel ka kaun sa वर्जन kar rahe ho
TheDataLabs
TheDataLabs 29 days ago
Excel 2016
zarko tripunovic
Really amazing video! Everything explained in details!
Divyanshu shrivastava
Developer option nahi araha h
TheDataLabs
TheDataLabs 29 days ago
To display the DEVELOPER tab, click on the File menu and then select Options from the drop down menu. When the Excel Options window appears, click on the Customize Ribbon option on the left. Click on the Developer checkbox under the list of Main Tabs on the right. Then click on the OK button.
Shivam Harnal
Shivam Harnal Month ago
hey i got run time error in show form code, will you please help.
TheDataLabs
TheDataLabs 22 days ago
Please share the line of code. Thanks
Abhisek Mishra
Abhisek Mishra Month ago
Am having end with error....kindly help
Barbette Diabordo
Thank you for this info. Sir, could you make a video about checkboxes? Since it is very commonly used in forms.
Supriya Ravi
Supriya Ravi Month ago
Iam getting error bro.. ambiguous name detected: Reset
Rami Signals
Rami Signals Month ago
Give abother name for module 2 like S_Reset ()
Anders Brinchmann
Hi DataLab Team, Fantastic tutorials! I have a question. How do I change one textbox to a checkbox and when the user check the box it provide a datestamp in the database. Thanks a lot Anders
Jagendra Singh
Jagendra Singh Month ago
Excellent, and pls add edit and delete, also
TheDataLabs
TheDataLabs Month ago
Thanks for your feedback! Please watch the other part of this tutorial. Have covered all features. Thanks!
Abhijeet Ranveer
Thank you very much ...for wonderful video
Rami Kanawati
Rami Kanawati Month ago
Hello can you button for the next record and previous record it will help more
Oscar Delight
Oscar Delight Month ago
Hi, Thanks so much for your great tutorial. I followed your instructions step by step in creating automated data entry form. When I finished and tried to save an entry, I was getting an error (Compile error: Sub or function not defined). It the highlights (private Sub cmdSave_Click()) I have attached a link of screenshot of all the errors I was getting in the link below. Please help. Thanks 1drv.ms/u/s!Ag8hnRm8CxVgpxxTFXmOlJn7bksf?e=6b3Fzc
Wayne Seymour
Wayne Seymour Month ago
I have a input data form that I use to input data as a Heavy equipment registry. Work is granted fairly across the board for all sub-contractors, I have the data input form that enteritis the names of the company's into a work sheet, I have a toggle button for work granted either "yes" or "no", next to those toggles I have a text box to record the amount of "yes" and the amount of "Mo" each company receives. once entered they will receive a no. However if in the future they are granted work I want when I up date their records that the txt box next to the toggle button to record how many "yes" the other to record how many "No" they have, so if their record is recalled it can show that result. It should be noted that the data has the company listed several times depending on the different types of equipment they have, some may have 7 dump trucks, several excavators. So no matter the number of entries for that company, I will still get how many "no's" and "yes's". I don't know the coding but....something like if txtowner.value =xx then Txtyes.value = cell.range F:F where xx and yes is true...something to that effect.
Bjorn Vega
Bjorn Vega Month ago
getting an error on the frmForm.Show, fixet the problem by removing (.lstDatabase.ColumnWidths = "30,60,75,40,60,45,55,70,70")
just habi
just habi Month ago
Can you tell me how to make a student form
just habi
just habi Month ago
hey when you teaching some of option i cannot understand
Rami Signals
Rami Signals Month ago
Hello Thanks for your videos again we are waiting part 6 Meanwhhile i was created same file from your videos and i add more sheets and more form But i get minor issue ( lstdatabase) for other sheets i put this name ( lstdatast) It will not show till i click on reset bottun Can you please advise
Saan Mohammad
Saan Mohammad Month ago
in frmForm i cant put any any number in Database (TabIndex)....after inserting any number (Like-1,2,3,4,5,6.7,8,9) its showing only "0''
Saan Mohammad
Saan Mohammad Month ago
during Debug of Save & Reset im facing this error msg ''Compile error: Ambiguous name detected: Reset'' pls help me out.....
Supriya Ravi
Supriya Ravi Month ago
Same issue
Ma. Diana Verdejo
Same issue with mine
Tariq raja
Tariq raja Month ago
Great Tutorial From A-Z very well Explained buddy . Thank you from Pakistan
Salman Ahmad
Salman Ahmad Month ago
can you tell me how to make an attendance sheet in MS Excel ?
TheDataLabs
TheDataLabs Month ago
Please watch this tutorial. Thanks! ruvid.net/video/video-UZytz90vZt8.html
kanc hana
kanc hana Month ago
U have done a good job yea.. I really want to learn more about user forms data entry. I have a problem on this data entry form and its shown run-time error '380': Could not set the ROssources property.Invalid property value.Pls assist me ..Thanks in advance
TheDataLabs
TheDataLabs Month ago
Thanks for your feedback! Please share the line of code where you are getting error.
Wayne Seymour
Wayne Seymour Month ago
I have a input data form that I use to input data into a work sheet, I would like to see the number of unique text for that person when I recall their data to the form. I want to count how many "yes" answers in a column for a particular person and pass it to my upnput form once the record for that person is called. is selected.I dont know the coding but....something like if txtowner.value =xx then Txtyes.value = cell.range F:F where xx and yes is true...something to that effect.
Wayne Seymour
Wayne Seymour Month ago
I followed your every step to recreat the input form with my own data and requirements but keep getting a runtime error 380 "could not set the rowsource property invalid property value" reviewed the code but cant see why I get this error...here is my code: Option Explicit Sub Reset() Dim irow As Long irow = [Counta(Database!A:A)] 'identify the last row With frmForm .TxtSerialNo.Value = "" .TxtOwner.Value = "" .CboMachineType.Value = "" .OptYes.Value = False .OptNo.Value = False .TxtTotalDays.Value = "" .TxtModel.Value = "" .TxtTotalHours.Value = "" .TxtCost.Value = "" .TxtRate.Value = "" .TxtFrom.Value = "" .TxtTo.Value = "" .TxtCost.Value = "" .TxtCuYdTransported.Value = "" .lstDatabase.Value = "" .Txtyes.Value = "" .TxtNo.Value = "" .CboMachineType.Clear .CboMachineType.AddItem "D5" .CboMachineType.AddItem "D6" .CboMachineType.AddItem "Dump Truck" .CboMachineType.AddItem "Excavator" .CboMachineType.AddItem "End Loader" .CboMachineType.AddItem "Roller" .CboMachineType.AddItem "Backhoe" .CboMachineType.AddItem "Caterpillar" .lstDatabase.ColumnCount = 12 .lstDatabase.ColumnHeads = True .lstDatabase.ColumnWidths = "30,60,75,40,60,45,55,70,70,55,45,30,30,70,55," If irow > 1 Then .lstDatabase.RowSource = "Database!A2:L" & irow Else .lstDatabase.RowSource = "Database!A2:L2" End If End With End Sub Sub submit() Dim sh As Worksheet Dim irow As Long Set sh = ThisWorkbook.Sheets("Database") irow = [Counta (Database!A:A] + 1 With sh .Cells(irow, 1) = irow - 1 .Cells(irow, 2) = frmForm.TxtSerialNo.Value .Cells(irow, 3) = frmForm.TxtOwner.Value .Cells(irow, 4) = frmForm.CboMachineType.Value .Cells(irow, 5) = frmForm.TxtModel.Value .Cells(irow, 6) = frmForm.TxtRate.Value .Cells(irow, 7) = IIf(frmForm.OptYes.Value = True, "Yes", "No") .Cells(irow, 8) = frmForm.TxtCuYdTransported.Value .Cells(irow, 9) = frmForm.TxtFrom.Value .Cells(irow, 10) = frmForm.TxtTo.Value .Cells(irow, 11) = frmForm.TxtTotalDays.Value .Cells(irow, 12) = frmForm.TxtTotalHours.Value .Cells(irow, 13) = frmForm.TxtCost.Value End With End Sub Sub Show_Form() frmForm.Show End Sub Private Sub cmbSubmit_Click() Dim msgValue As VbMsgBoxResult msgValue = MsgBox("Do you want to save the Data?", vbYesNo + vbInformation, "Confimation") If msgValue = vbNo Then Exit Sub Call submit Call Reset End Sub
kanc hana
kanc hana Month ago
Same Problem 😅..
Rami Signals
Rami Signals Month ago
Super We need multi user form with multi sheets in one file For exmple user form 1 is the data for sheet number , userform2 is the data for sheet 2 We need to do 15 sheets and 15 user form in one file Search + save + printing + Reset+edit + delete buttuon for each user form and each sheet Itry this but i got conflict in modules please make some videos it will be help full Thanks
TheDataLabs
TheDataLabs Month ago
Thanks for your feedback! Please watch this tutorial. Hope, it will help you. Thanks! ruvid.net/video/video-ehrGvarWqiY.html
Hiranthe
Hiranthe Month ago
You are a champion Dilip Kumar. Thank you for the great work. I want to create a register based on your tutorial. May you be blessed with more wisdom and success.
Fazal & Meags Hamid
Hi, thanx for sharing this. I am trying to create a user form similar to what have shown here, and I built it pretty much the same way you showed. I am using the Data picker activeX control for users to choose a date (for the transactions, which the database is based on)...when I go to run my form I get an error "Run time error '35787': Can't set Value to NULL when CheckBox property = FLASE....any suggestions?
Joanne Belen
Joanne Belen Month ago
why i cannot find my user form it shown only module and class mode
Next videos
Excel 2016 Advanced
2:38:45
Views 525 000