Add Data to Specific Sheet from User Form - Advanced Excel VBA Userform 

Very useful info...Thank you for sharing!!!

When I click the Transfer Data button, this message box pops up "Compile error: Variable not defined". The Code is exactly the same as in your video. Any solution for this?

Can Search command be added in this form to search from both pages?

Awesome guide!

can you teach me how to searh update with this project ? thank you

Super sir. But update data and delate row data format plage video sir

I'm having issues with your code last row = ActiveSheet.Cells(Rows.Count, 1).End(x1Up).Row

Hi. How do I use this form for the newly added sheets? I mean, how does the combobox automatically detect the new sheets added when we export new data into a workbook?

Sir how to add search and update button in this userform

Dear Sir, Great work... I want to know about my problem if you can help me, 1. I have say 5 sheets 2. Every sheet has different data 3. I have created 5 data entry form 4. I have a master sheet where i have command button to show the form, where I have a label and a text box in which i shall insert the date that is common for all 5 sheets. 5. After date I have combobox with five sheet names, when I select a name from , its respective form must be open and transfer data from that form to selected sheet. I need your help or suggestion or modification if you can Regards

its not working for me, data is not being transferred to selected worksheet.

Hi i must say productive lesson for excel students ! here i want to ask you after watching this video , suppose despite using first , second and third sheets how can we use one sheet where we make tables of first, second and third and transfer data with the help of combobox to specific cells ? i hope u get my question. regards

Do you have a version of this form that allows you to use existing data (sheet 1) to specific sheets within the work book. For example, I have 100 students who are listed on sheet 1, and I want to move some of these students to sheet 2, some to sheet 3, some to sheet 4. Kind Regards, Craig

This is somewhat helpful. However, if you were to make the Excel file used in the demonstration video available, it would be much more useful.

can u pls put the link to download this File ???

NICE ,LIKE TO LEARN THHIS ,BUT I DNT KNOW WHERE TO BIGEN

Thank you so much sir ❤️ And one more question Is it possible to transfer same data to 2 specific sheets together ? If yes then please tell us how ?

Sir, Could you do a project on Tree view control on user form in excel!

I used this and it worked well within the same workbook. How do I get the userform to add data to another workbook?

What if you want to modify data on the worksheets?

Excellent..... but sir is it possible to selected different columns ranges in the same sheet for different years Ex 2019 jan to dec, 2020 jan to dec... So on

Need Help it shows error 13 and make the line highlight "ActiveSheet.Cells(lastrow + 1, 1).Value = Serial_Number.Value"

It's a very useful sir, but i have a question❓ Can we write something according to searching any text that is written in any row or Column

Sir, How Can i add listbox in this userform?

Dear sir your video is very good and useful...I need your help in one area...in this userform I want to add search button and update button...when I search the particular data of particular sheet...I could able to update the data also...please provide the codes for that and how can we do that...it's very urgent sir.I will be highly obliged.

Hi Sir Good Morning, I always watching your videos and Learning Very Nice. Can you Tell me How to do Codeing if I want SEARCH and UPDATE In this Userform.plz... Thank you.

Thank you so much sir, I have one query, I have formatted Table with Total Row enabled in each Worksheet. As per your code data is being transferred to the next available empty row after Total Row. How to add data before Total Row. Please help me.

SUBSCRIPT OUT ERROR WHAT CAN I DO

Thanks for sharing the, can we avoid to adding duplicate data based on values in specific column?

nice learning I have huge data file want to split into two or three sheets, some of the fileds are common for all the two/three sheets, can u guide how to do vba coding.

It really helped sir, Thanks for your video.

very useful..thank you

Really sir very nice video...I would like to ask one question....if I want to check duplicate entry...suppose same phone number is exist in any sheet then how can we know about that sheet name and cell address before transferring the data plz guide me

Thanxx

Excellent vidéo , Thanks... Thanks.

hello sir how to search from sheet1 and sheet2

Thanks, Sir. But please help me with the excel work so that we can get access to the code.

Thanks bro

dir sir, when the target sheets are protected sheets do you know the vba code? Thanks Chris from Holland

This code works for table format Thanks

Can we transfer data to different column instead of different sheet ?

How about if we want to start the value from row 5 or any others rows?

Thanks Sir... i need this in excel formate. need code.

Very Good...

Hello There, The code is working fine. However there is one issue. On the workbook which I've made there are two worksheets. The first one is named "HOME" and the 2nd is "RawData". To run the userform, one will have to click on a command button which is on "Home" worksheet. Whatever data is entered in the userform form, should copy in "RawData" worksheet. However, it's not happening. The userform is copying the data under "Home" worksheet. There is one more thing I've noticed. When I'm on "RawData" worksheet and runs the userform, by using developer tab, it copies the data correctly From the userform under the specified row and column in "RawData" worksheet. However it's not copying the data to "RawData" worksheet when I run the userform from "Home" worksheet. Instead its copying it on "Home" worksheet. Please guide me with the correct VBA coding, as I've tried changing the worksheet name as well on the VBA codes shown inthe video, but it didn't make any difference. Thanks.

Nice explanation, thanks

It keeps entering data into the same cell, it doesn't move down a cell after data is entered. Any ideas?

Hello ! Please, how could you format TextBox3 so that the numbers transfered to spreadsheet would not be a string but an Integer ?

thank you so much for this

Sir how we create excel page through user form in excel like a inventory software???

Excellent

Sir please help i want to chage every time cell range when vba run plzz make user form which ask cell rang when vba run after vba run

Sir Pls make a update,delete,view commond button

Sir Pls make a update,delete,view commond button

how to solve compiler error targetsheet because Variable not define pls help me

Thank you for this informative video... But while I was running the code I was getting variable not defined error...i.e targetsheet and last row not defined.... When I defined it... the code ran successfully...just wanted to ask how come you didn't get the error as you have no where defined targetsheet and last row in your video... I am new to Excel Vba and userforms...so kindly clarify.....

Are you able to send the VBA code to my email or paste a link where I can access it?

I try to do this but can, t. Debug for object. How is that?

Perfect.

Hello brother please how can i insert my user form from VBA to my sheet ?

Not working when protected.

i face error in this code i have type WorkSheet(TargetSheet).Active but it show me the Error how to fix it

Nice explanation, Everthing is correct mentioned in userform but still not activate the target sheet & transfer the data. Pls help.. May I share the file give me your mail id.

Thats really good and clear guide..... Thanks... Can we transfer data to different column instead of different sheet ?