LOVED THE VIDEO!

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

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

AMAZING APPLICATION EXCEL VBA

Informative speech

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

So thanking you brother

thank you

THIS IS AMAZINGGG! thank you so much!

Its Very Helpful

God bless u

Thank sir very useful...

nice tutorial

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?

Thanks sir

Really very useful and well explanation dear friend

@thedatalabs

3 жыл бұрын

Thanks for your feedback!

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.

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

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

Very nice

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 ?

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

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.

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

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

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

@thedatalabs

2 жыл бұрын

Thanks for your feedback! Please watch this Google Sheets Tutorial. kzread.info/dash/bejne/fJ6ntpVtnsbOd5c.html

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...Can you make one video of Multiple Database Sheet with Search, Edit, and Delete buttons ?

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

2 жыл бұрын

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

Very much thanks if do like this in google sheet

@thedatalabs

3 жыл бұрын

Please watch the same tutorial for Google Sheets. Thanks! kzread.info/dash/bejne/fJ6ntpVtnsbOd5c.html

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

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

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

3 жыл бұрын

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

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

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

@thedatalabs

3 жыл бұрын

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! kzread.info/dash/bejne/g2F90ZKSZZzUiaQ.html

@lukaspalintong

3 жыл бұрын

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

3 жыл бұрын

I will try uploading a tutorial on that. Thanks!

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?

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

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

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

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

@thedatalabs

4 жыл бұрын

Thanks for your feedback! You need to create dynamic drop-down. Please watch this video to learn how to create dynamic drop-down. Thanks! kzread.info/dash/bejne/mGuLlaqLfLS_cdY.html

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

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

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

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

3 жыл бұрын

Please watch this tutorial. It will cover the validation part. You can apply the same logic and code. Thanks! kzread.info/dash/bejne/YpZ6sa2pkbavcso.html

@johnmichaelparecto5167

3 жыл бұрын

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

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

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.

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

4 жыл бұрын

Thanks for your feedback! Please watch this tutorial. kzread.info/dash/bejne/e2GOx5ibiJrVpdY.html

@easygetprojects8285

3 жыл бұрын

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

@tronway5500

3 жыл бұрын

How do you apply that code to this form

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

@thedatalabs

3 жыл бұрын

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

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.

Can you help us adding a search function please.

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?

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

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

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

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

@thedatalabs

4 жыл бұрын

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

@Muhammad_Sakil

4 жыл бұрын

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

Hello, do you have the form for Journal entry?

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

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

2 жыл бұрын

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

sir, what is the code for delete and modify button

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

3 жыл бұрын

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

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

4 жыл бұрын

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. kzread.info/dash/bejne/e2GOx5ibiJrVpdY.html Thanks

nice tutorial really, except the audio

can we do the same in google sheets ?

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

3 жыл бұрын

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

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

@thedatalabs

4 жыл бұрын

Please check the worksheet name used in code.

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

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

4 жыл бұрын

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

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

@thedatalabs

4 жыл бұрын

Yes, you can use lookup in VBA code .

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

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

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

3 жыл бұрын

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

@faizsumbal

3 жыл бұрын

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.

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

3 жыл бұрын

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

Greetings, how do we do the same on Google sheets

Sir how to search in multiple sheet plz give video link

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

I need this in Google sheet.

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

@thedatalabs

3 жыл бұрын

Yes, that's possible.

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

@thedatalabs

3 жыл бұрын

You can apply the same logic. Thanks!

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

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

4 жыл бұрын

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

4 жыл бұрын

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

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

How to add a search button to this?

@thedatalabs

4 жыл бұрын

Please watch this tutorial. We have discussed all features. Thanks! kzread.info/dash/bejne/e2GOx5ibiJrVpdY.html

Why We save file name into micro enable ...

@thedatalabs

4 жыл бұрын

Macro enabled file retains the macro code.

How to do this in userform vba

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

3 жыл бұрын

U got the solution? Even I want to know!

@sadupadhananjaya3504

3 жыл бұрын

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

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

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

3 жыл бұрын

Please watch this tutorial. Thanks! kzread.info/dash/bejne/e2GOx5ibiJrVpdY.html

@sadupadhananjaya3504

3 жыл бұрын

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

3 жыл бұрын

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

I need your help

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

@thedatalabs

3 жыл бұрын

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

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

3 жыл бұрын

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

@blaowpow61

2 жыл бұрын

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

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

@thedatalabs

3 жыл бұрын

Please share the error message and line of code where error is showing. Thanks!

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

3 жыл бұрын

Hope, you will find this tutorial helpful. kzread.info/dash/bejne/g4x_ma96ZdbHZJc.html

@ajaybote3377

3 жыл бұрын

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

@ajaybote3377

3 жыл бұрын

Will you help bro🙏

@mci8313

2 жыл бұрын

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

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

@thedatalabs

3 жыл бұрын

Will upload a tutorial for Google Sheets. Thanks!

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

9 N

I need your help, please contruct.