UserForm with Multiple Database Sheet (Transfer Data to Worksheet on Condition)

[@pakistankayrangaakaysung]

Thank. I am beginner but by this video I learnt so many things with techniques.

[@greenapple7005]

I am a property handling guy and managing my inventory has always been an issue for me. With this video I can log my properties in respective sheets. I wish if there were some filters features also added to search the desired property by means of its Price range, by Size, by Type and by date. Overall a great great help. I truly appreciate and admire the dedicated work done in this video. Grateful // IQBAL

[@bryce867]

Informative speech

[@yogeshpadte1481]

thank for the call log form. Looking forward for a similar Log form for maintaining incoming outgoing cash flow in coming days. thanks

[@annefgm]

Thank you so much sir😍 you really help me solve my vba problem

[@RakeshBairaria]

Thanks. Very precised yet brief. What modification would it require to trnasfer data from one form to two different sheets. Thanks in anticipation.

[@ckumarmehta8370]

Thanks!! Nice video to learn something new..

[@storekeeperTips]

Really very useful and well explanation dear friend

[@thedatalabs]

Thanks for your feedback!

[@poosalaanil5754]

Its Very Helpful

[@akio6505]

Thanks! How do you share just the form and super hide the sheets as entries will be confidential?

[@naniroses129]

So thanking you brother

[@PaulEllisBIGDATA]

LOVED THE VIDEO!

[@bestof9764]

AMAZING APPLICATION EXCEL VBA

[@sreejithkrishnan1111]

Thank sir very useful...

[@scottmcintosh9396]

How to code to insert new row below headings and add a new entry there?

[@naresh6943]

Very useful video, hats off to u! Also, could u make similar video for Google Sheets as well?

[@thedatalabs]

Thanks for your feedback! Please watch this Google Sheets Tutorial. kzbin.info/www/bejne/gJvWhWZqo8ibfZY

[@kapaunkelo6939]

Hi...Can you make one video of Multiple Database Sheet with Search, Edit, and Delete buttons ?

[@onedaytradingcrypto2758]

nice tutorial

[@mansoorali19]

Very nice

[@lindleybulado9203]

Hi there. Thank you for the free tutorial. How it is done if you want the data entry to one sheet only but different cell columns

[@karnank6934]

God bless u

[@oediarti2012]

Thanks sir

[@whatsnext6598]

Great video... Sir can you make a video on were we use listbox in VBA with multiple select and how does it appear on database sheet, or does it appear in one cell ?

[@user-Fatima.BHA.Shaikh]

If we have used check boxes for yes or no in our excel form can we still get all the data in excel as you have shown in this video?

[@cupidtablets5042]

Good Morning to you today Yr indeed an excel expert. we appreciate all you do for us. my contact manager is challenging me. when i save a contact, it overwrites the one i saved first. i therefore keep finding the last saved record and i cant access the earlier saved records

[@thedatalabs]

Thanks for your feedback! Please check the variable used to store row number.

[@pkmnamboothiri]

Very good explanation. Hats off. Big Salute sir.. Could we add two more keys instead of 2. Means 'Delete' and 'Modify' in the same data entry? Then what will be codes? I have already seen your other videos for that. But if my search criteria are two how can I add it?

[@ravishankar9289]

Can you make video on how to share userform data to other onedrive accounts

[@johnmichaelparecto5167]

Hi Sir your code works perfectly. But I have one concern what code needed to give an error message that field required entry? Where to add it in the code you created in the video?

[@thedatalabs]

Please watch this tutorial. It will cover the validation part. You can apply the same logic and code. Thanks! kzbin.info/www/bejne/ZpOpgH6mlrh8eMk

[@johnmichaelparecto5167]

@@thedatalabs sir I checked the link but it is not helpful How I wish you can create a video or share a code for validation in this entry you made in this video.

[@sadupadhananjaya3504]

@TheDataLabs sir I need the coding for modify and delete buttons for a data entry form with multiple data sheets, I have watched this video too. But this is regarding single data sheet. how can I do it with multiple data sheets. I can't understand. please help me sir.

[@tapan4253]

thanks but i have one doubt, call summary auto fit because if we will put any thing like 4 or 5 lines then it will take proper space there in another sheets and second thing is I need to creat a button and in that button open this open when I will on it. if it possible then how? plz let me know

[@reubenaguti2165]

Can 2 data entry forms submit data onto the same Excel sheet tab having the database, if one form has 18 text boxes and it is submitting from A2 to R2 with the buttons Save, Reset, Print, Edit, Exit, and Delete and the second form has 20 text boxes and it is submitting from S2 to AL2 with "submit" and "return" buttons on the second form to go back to the first form again

[@TareenAbrar]

If the data needs to be submitted into other files then ?

[@RohiniGgude]

Can you make a video adding data on top below header in above userform though I have watch that video in which u show how to add row but I want to apply code in above userform can you pls help with apply code in above userform 🙏

[@mci8313]

U got that solutions plz share with me I also looking for that

[@lukaspalintong]

Amazing. I've been looking for this tutorial for long time. Will this work on Google Sheets?

[@thedatalabs]

Thanks for your feedback! This is for MS Excel only as Google Sheets doesn't support VBA. Please watch the below tutorial for Google Sheets. Thanks! kzbin.info/www/bejne/h16soGOPap6hj6M

[@lukaspalintong]

@@thedatalabs Thank you for answering me. I need to transfer data to multiple sheets based on a condition as described in this video. I have already search your entire videos for Google Sheets but don't find any relevant tutorial yet.

[@thedatalabs]

I will try uploading a tutorial on that. Thanks!

[@timcrouse8475]

Is there a technique to have each of the data sets stored on the same sheet but in separate sections each with its own header row?

[@lindseyleicester5203]

This video is amazing and has helped me so much. Please could you tell me how I can allow data entry onto a protected sheet using the user form?

[@angieandrews8793]

I have a question about this. I created a form to match what I needed. However, I have a second form on the form sheet that has credit card data for the customer calls. But when I hit submit it disappears. How can I make it that the other information clears after I submit, but not the credit card info on the other section?

[@jvnvzo]

Hi. Cool video. Is there a way where you can add SEARCH bar to search and display entry then add notes? And when the new NOTES are added, it will show a thread of notes. Just like Call Center CRM where you can add notes on an account or entry.

[@JenJen-fe6us]

Hi what if i need to transfer data to specific cell in that sheet. Not just the next available blank row. Example customer name should be transfered to cell B17 in that sheet

[@tqv012006]

Thank you so much. But I couldn't download the file

[@abdusalih3811]

thank you

[@nikklim2504]

Thanks for this video, i was able to make my project lately..straightforward and awesome ,but i have questions 1. how can i direct the cursor directly on the first data entry field in form and then to go to next entry field using enter or tab?i should also my cursor when needed? 2. in my list (which is the sheet), i wanted to show a blank row in between entry not every row, code please and where to place them in code? Thank you in advance.

[@TheDramaticirony]

Hi. How do you add new data in without overwriting the existing data in the list ? I tried your method and the data will start from the first row, overwriting my existing data

[@CCAFO]

Hello, do you have the form for Journal entry?

[@mohammadzaid460]

Sir indeed this was great video and much helpful. Is it possible to save the same data in multiple sheets? If yes please let know how to do that

[@saniak5262]

please share if you find the solution. I am looking for that too. Thank you

[@namreshchor]

Hi I have seen many of your data entry and all are very useful .can you help me with different type of data base entry .for example in store . we need some parts/items . item number its location and description .with add item and search item and delete item

[@koungsareth8623]

Very much thanks if do like this in google sheet

[@thedatalabs]

Please watch the same tutorial for Google Sheets. Thanks! kzbin.info/www/bejne/gJvWhWZqo8ibfZY

[@tronway5500]

Can you help us adding a search function please.

[@bhawyakumar1054]

Hi, i want to export data from excel sheet to userform combobox and date picker however, .value and.list doesn't work what object should be used

[@Ashokthebull]

I followed the command. It is working and thank you for that. But there is a small error,, I have added just two options in the drop-down. Codes works perfectly fine, when I choose the 1st option to save. When I choose the second option datas are saved from bottom of the table not from top. Could you please guide me on where I went wrong? Thanks in advance!

[@Elucas89]

How in the code can I also send the form inputs to a master database sheet. So that the form inputs go to the country and also to a master database.

[@poosalaanil5754]

Could you pls provide App Script code for google sheets..It will helpful to us

[@johnmichaelparecto5167]

Hello can you add sample coding in this entry to validate data? I am having trouble following the other tutorial .

[@sandip01_11]

Sir Delete, Update button alao need in this form??

[@lourdvicalcindor2910]

Hi ! Thanks for this video ! Is it possible to submit the data into already existed worksheet or we need to recreate them from scratch ? Thanks

[@AtanuDigital.]

Please create a Small banking system Like Castomar profile Savings account Loan

[@theactionlab2186]

Can i get the source file(excel) of this userform

[@airexpressgsacrescentstari9443]

Great job One question is if we would like to submit data in 2 sheets with on submit click is it possible??????

[@thedatalabs]

Thanks for your feedback! Yes, that's possible.

[@mukhlisbuneri]

very nice video Sir.... how it will select newly inserted sheet(means other country) automatically in form dropdown list.??

[@thedatalabs]

Thanks for your feedback! You need to create dynamic drop-down. Please watch this video to learn how to create dynamic drop-down. Thanks! kzbin.info/www/bejne/nGi6ZHuIgbaMd9U

[@sadupadhananjaya3504]

sir, what is the code for delete and modify button

[@navaneethakrishnan4829]

Awesome 👍 I'm impressed sir... Please tell me how to add search options in this entry sir... Please help us sir... If possible tell me how to avoid duplication..

[@thedatalabs]

Thanks for your feedback! Please watch this tutorial. kzbin.info/www/bejne/f169lmmYjZyiq9U

[@easygetprojects8285]

I've watched the tutorial but still unable to search data from other worksheets using this form. Please help

[@tronway5500]

How do you apply that code to this form

[@ramitamahato7609]

How to make UserForm with Multiple Database Sheet (Transfer Data update delete search to Worksheet on Condition)

[@thedatalabs]

For rest of the features you can take help from our other Tutorials. Thanks!

[@jamesmwanza4289]

Greetings, how do we do the same on Google sheets

[@krob123085]

Would you mind taking a look at my coding to see why I keep getting an out of range error code?

[@thedatalabs]

Please send it. I will go through that and let you know the reason of error and fix it. Thanks!

[@Muhammad_Sakil]

@@thedatalabs give me your email or whatsapp no....

[@Tieu72]

After I build this when I close the file it doesn't save. How do I do that? Thanks.

[@naveedasghar3022]

Hi nice video! i have a question instead of using different sheets for countries if we use one sheet where we put country names horizontally by selecting country from form data will transfer to specific cells.Hope you understand what i am asking?kindly make a video about it thanks & regards

[@heng9876]

THIS IS AMAZINGGG! thank you so much!

[@Rheyaleng]

Hi sir can you add another button for update? I was able to add another button for modify but it's not saving the updated data 😢

[@deeiskhan3781]

hello, I would like to ask why I can't add more data, and it replaces the row that i had just add? can you help me to fix this?

[@thedatalabs]

Please check the row variable. It should not be static. Thanks!

[@odraude8773]

nice tutorial really, except the audio

[@omnathlamsal6036]

Sir how to search in multiple sheet plz give video link

[@davidsumner397]

Hello Sir, I keep getting a Subscript out of Range Error on set shCountry =ThisWorkbook.Sheets(sCountryName). i can send the code to you if you have the time to look it over. the sheet name is the same as in the code so it must be somthing i am over looking in the code

[@kimrasalan617]

Me too..can i get a response out of this error

[@msalam353]

Showing "Subscript out of Range" Error Please help on that issue

[@daljeetsingh1231]

I am using Userform1 multiple times in different Excel worksheets. But, If I select Checkbox in the first Userform then another Userforms checkbox automatically selected. How can I separate them? I'm a beginner in coding so do not have much idea how can I segregate them to perform individually.

[@kriti4698]

can we do the same in google sheets ?

[@thedatalabs]

Yes, please check our Google sheets tutorial. Thanks!

[@bmmmjm7823]

Hello Sir, would you mind taking a look at my coding to see why I keep getting an error code?

[@abeermuhammed2544]

Hi there May your help please It works for the 1st time, and now asking me to correct the error on the code Set shCountry = Thisworkbook.Sheets (sCountryName) I have tried to put quotations marks for (“sCountryName”) And still not working The message is ( run time 9 : subscript out of range) Your help please

[@thedatalabs]

It seems the country name selected in drop-down has no respective sheet in this workbook. Please check. Thanks!

[@lourdvicalcindor2910]

Is it possible to transfer data in multiple sheet in the same submit ?

[@thedatalabs]

Yes, that's possible.

[@faizsumbal]

Dear Sir, I am facing the same problem. Let me mentioned I have used your coding and excel sheets design too, but still experiencing Run-time error '9' "Subscript out of range ..... Set shCountry = ThisWorkbook.Sheets(sCountryName).....please advise what to. I have checked sheet name used in coding many a time that is perfact.

[@thedatalabs]

Please check the sheet name and use in bracket with double quotes. Hope it will work. Thanks!

[@faizsumbal]

Dear Sir, I have send an email and attached the Excel file with developer codes. My request is to please and check it and advise me how to remove the error. Thanks.

[@greenledenterprises7613]

1. How can I "Delete" row from multiple Database sheets? 2. How to "Modify" row from multiple database sheets?

[@sadupadhananjaya3504]

@TheDataLabs I really want this sir. Coding doesn't identify the selection of datasheets for modify and delete buttons when giving the serial number and it gives no record found though there is data in particular row. please help me to solve this problem sir. Shall I sent my project to your email if you can look at it sir.

[@Ed-xb3sr]

Hi! Hoping you would see this. I'm having problem with the program, in the "Sub Submit_Form()" it says 'Compile Error: Variable not defined' i don't know what to do here now.

[@thedatalabs]

Could you please share the line of code where this error coming? Thanks!

[@craigyamasaki8315]

is there a way to populate the data from the form to separate workbooks?

[@thedatalabs]

Yes, you can use lookup in VBA code .

[@KaviRaEnterprise-k1u]

I need this in Google sheet.

[@AjazAlam09]

How to do this in userform vba

[@kale9915]

Hi how about if i want to separate between currency? for example if multiple tabs is USD,EUR,AUD..so each tab will have each currency, in video u show separate at multiple tabs based on countries..can u help me on this

[@thedatalabs]

You can apply the same logic. Thanks!

[@kaushalsinghrana7896]

Sir agar ye wala formula google sheet main lagana hai to.kaise karenge

[@thedatalabs]

Will upload a tutorial for Google Sheets. Thanks!

[@krob123085]

How to add a search button to this?

[@thedatalabs]

Please watch this tutorial. We have discussed all features. Thanks! kzbin.info/www/bejne/f169lmmYjZyiq9U

[@ajaybote3377]

Hi bro I need your help in your userform I want always enter data on top below the header, can help me with coding? It's urgent 🙏

[@thedatalabs]

Hope, you will find this tutorial helpful. kzbin.info/www/bejne/h4muaIB3atiUapY

[@ajaybote3377]

@@thedatalabs Thanks for this but can you plz help me with applying same code in this above userform.

[@ajaybote3377]

Will you help bro🙏

[@mci8313]

Bro u got ur solutions to add data on top row plz share

[@sadupadhananjaya3504]

Sir can you tell me the code for modify and delete buttons for this kind of data entry form. I'm stuck in that case. please help me to solve this problem. please

[@thedatalabs]

Please watch this tutorial. Thanks! kzbin.info/www/bejne/f169lmmYjZyiq9U

[@sadupadhananjaya3504]

@@thedatalabs sir I need the coding for modify and delete buttons for a data entry form with multiple data sheets, I have watched this video too. But this is regarding single data sheet. how can I do it with multiple data sheets. I can't understand. please help me sir.

[@sadupadhananjaya3504]

@@thedatalabs I really want this sir. Coding doesn't identify the selection of datasheets for modify and delete buttons when giving the serial number and it gives no record found though there is data in particular row. please help me to solve this problem sir. Shall I sent my project to your email if you can look at it sir.

[@michcampos9336]

Can you send me a copy of that file? Thank you

[@diya2909]

Very awesome video sir...please guide us if we want to stop to enter duplicate customer I'd...for example if same customer I'd exist for India...in this case what can we do

[@thedatalabs]

Thanks for your appreciation! You can apply an additional validation to check customer id is already available or not. To validate, you can use match function in VBA. Please watch this video. kzbin.info/www/bejne/f169lmmYjZyiq9U Thanks

[@sruthisuresh391]

Hi! Hoping you would see this. I'm having a problem with the program, in the "Sub Submit_Form()" it says 'Compile Error: Variable not defined' i don't know what to do here now. Sub SUBMIT_DETAILS() Dim SHINDENTOR As Worksheet Dim SHFORM As Worksheet Dim ICURRENTROW As Integer Dim SINDENTORNAME As String Set SHFORM = ThisWorkbook.Sheets("FORM") SINDENTORNAME = SHFORM.Range("E12").Value Set SHINDENTOR = ThisWorkbook.Sheets(SINDENTORNAME) (here is the problem) ICURRENTROW = SHINDENTOR.Range("A" & Application.Rows.Count).End(xlUp).Row + 1 With SHINDENTOR .Cells(ICURRENTROW, 1) = ICURRENTROW - 1 .Cells(ICURRENTROW, 2) = SHFORM.Range("E6") .Cells(ICURRENTROW, 3) = SHFORM.Range("E9") .Cells(ICURRENTROW, 4) = SHFORM.Range("E12") .Cells(ICURRENTROW, 5) = SHFORM.Range("E15") .Cells(ICURRENTROW, 6) = SHFORM.Range("E18") .Cells(ICURRENTROW, 7) = SHFORM.Range("E21") .Cells(ICURRENTROW, 8) = SHFORM.Range("E24") .Cells(ICURRENTROW, 9) = SHFORM.Range("E27") .Cells(ICURRENTROW, 10) = SHFORM.Range("E30") .Cells(ICURRENTROW, 11) = SHFORM.Range("E33") .Cells(ICURRENTROW, 12) = SHFORM.Range("E36") .Cells(ICURRENTROW, 13) = SHFORM.Range("E39") .Cells(ICURRENTROW, 14) = SHFORM.Range("E42") .Cells(ICURRENTROW, 15) = SHFORM.Range("E45") .Cells(ICURRENTROW, 16) = SHFORM.Range("E48") .Cells(ICURRENTROW, 17) = SHFORM.Range("E51") .Cells(ICURRENTROW, 18) = SHFORM.Range("E54") .Cells(ICURRENTROW, 19) = SHFORM.Range("E57") .Cells(ICURRENTROW, 20) = SHFORM.Range("E60") .Cells(ICURRENTROW, 21) = SHFORM.Range("E63") .Cells(ICURRENTROW, 22) = SHFORM.Range("E66") .Cells(ICURRENTROW, 7) = Application.UserName .Cells(ICURRENTROW, 8) = Format([now()], "DD-MM-YYYY") End With SHFORM.Range("E6,E9,E12,E15,E18,E21,E24,E27,E30,E33,E36,E39,E42,E45,E48,E51,E54,E57,E60,E63,E66").Value = "" MsgBox " Data Submitted Successfully" End Sub

[@thedatalabs]

Could you please let us know which line of code is getting highlighted after error message? Thanks!

[@blaowpow61]

@@thedatalabs I have a similar issue. Can you assist via email?

[@sadupadhananjaya3504]

sir, how to edit the userform and save data to the same record in a particular data sheet when there are multiple datasheets .please help me sir

[@mohammadzaid460]

U got the solution? Even I want to know!

[@sadupadhananjaya3504]

@@mohammadzaid460 No I didn't get the solution. Did you get it?

[@averagerebuilders5188]

Hello Sir, I keep getting a Subscript out of Range Error on set shCountry =ThisWorkbook.Sheets(sCountryName)

[@thedatalabs]

Please check the worksheet name used in code.

[@sameerarajapaksha-sy8rz]

When i go to save the document, there is a massage " Be careful ! Part of your documents may incuded personal information that can't be remove by the document inspector " please assist me.....

[@RameshS-v9f]

Goto security and disable

[@dharmeshpatel1138]

I want to make something in excel using vba forms....for my c-store daily sales activity..if you can help me...i really appreciate

[@thedatalabs]

Please share your requirements on our email id. You can find our contact details in description box. Thanks!

[@mhhridoy6246]

I need your help

[@colw8625]

I am have a problem with code, I have gone over it many times but keeps coming back with “can,t execute code in break mode “ and high lights the row.? Can I email the vba print out. Thank you

[@thedatalabs]

You have added break points in code. Please clear all the break in VBA window. From the Debug menu in VBA, choose Clear All Breakpoints (CTRL+SHIFT+F9). Thanks!

[@colw8625]

@@thedatalabsThank you for your very fast reply to my email, sorry no luck. Enter data into the form press submit button, comes up with do you want to reset this form, select Yes, form is cleared, but no data transferred to in any sheet. Pressing the reset button brings up a screen, runtime error, application defined or object to find error. Then shows the Icurrentrow..... in yellow. Any suggestions, Thanks Colin Worthy

[@Rahul_Seth]

Why We save file name into micro enable ...

[@thedatalabs]

Macro enabled file retains the macro code.