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

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

LOVED THE VIDEO!

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

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

Thanks!! Nice video to learn something new..

Informative speech

AMAZING APPLICATION EXCEL VBA

Its Very Helpful

So thanking you brother

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

thank you

Thank sir very useful...

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?

God bless u

nice tutorial

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

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.

Really very useful and well explanation dear friend

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

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 ?

Very nice

THIS IS AMAZINGGG! thank you so much!

Thanks sir

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?

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.

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

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!

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

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

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

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

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

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

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

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

@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.

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.

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

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

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?

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

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

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

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

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

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

@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.

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.

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

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?

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

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?

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..

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 🙏

Very much thanks if do like this in google sheet

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

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.

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

Can you help us adding a search function please.

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

nice tutorial really, except the audio

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

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

Please tell me entry code for transfering data to sheets of more than 25 parties

Hello, do you have the form for Journal entry?

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

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

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

sir, what is the code for delete and modify button

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

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

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

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?

Greetings, how do we do the same on Google sheets

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 😢

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

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

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.

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

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

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

Why We save file name into micro enable ...

How to add a search button to this?

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

I need this in Google sheet.

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

How to do this in userform vba

Sir how to search in multiple sheet plz give video link

I need your help

hello sir do you have what apps or email i want to ask you something sir... t.q

hi sir can you help me on this? it has an error

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

can we do the same in google sheets ?

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

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

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.....

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

I need your help, please contruct.

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

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 🙏