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

[@lakhera24]

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

[@sigmatabs9814]

It really helped sir, Thanks for your video.

[@ExcelDestination]

Welcome

[@Hash_Mohd]

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

[@ExcelDestination]

Yes, definitely

[@elijahsmart6010]

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

[@chanmonanrie6898]

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?

[@AP-rv1qn]

i have the same, he needs to define his variables.

[@chanmonanrie6898]

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

[@LizzieW71]

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

[@gajananpore4746]

Nice explanation, thanks

[@ExcelDestination]

welcome

[@c.kattenberg9279]

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

[@ExcelDestination]

you can take help from below given tutorial : kzbin.info/www/bejne/d3aWg2iNfMyXgMU

[@c.kattenberg9279]

@@ExcelDestination thank you sir, but this video is about protected or unprotected all sheets, my question is is there any code to protected or unprotected only the target sheet? ?

[@heyaedhiii]

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?

[@unuskpm]

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.

[@BedtimeRomance]

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

[@muraliiyer7850]

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.

[@ExcelDestination]

If you have this Project and want expert support, you can write email to [e-mail]

[@chadsummers6565]

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

[@dairy831]

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

[@sameeharox]

try "A" for column number (instead of 1), and it's xlUp (the letter "l" and not number "1").

[@saimusic9584]

Sir how to add search and update button in this userform

[@TheKlajmaS]

Awesome guide!

[@munnanurvenkat9014]

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

[@mgpkumar9190]

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

[@saupham8192]

This code works for table format Thanks

[@CMP1307]

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

[@naveedasghar3022]

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

[@ExcelDestination]

yes

[@naveedasghar3022]

@@ExcelDestination then kindly guide us what will be the coding for that !! if possible make a video. thanks & Regards

[@tcyaw0011]

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

[@ExcelDestination]

you can use that in looping statement

[@ebruhanim9562]

very useful..thank you

[@phillipspadaro2252]

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

[@ronolds6505]

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.

[@shambhoogupta8575]

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.

[@shambhoogupta8575]

Hi sir Can you Suggest me what Codeing work if i want to Search and Update Data in any specific Worksheet.plz

[@ExcelDestination]

you can take help from following tutorial : kzbin.info/www/bejne/Z5zTg5Rmj5tgb8k

[@shambhoogupta8575]

Sir I am beginner .This tutorials are only for transfer data to specific sheet.If am Adding SEARCH and UPDATE command then.What will be CODE Plz Tell me... Thank you.

[@sea-byeok7087]

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

[@onedaytradingcrypto2758]

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

[@MohAboAbdo]

Excellent vidéo , Thanks... Thanks.

[@sahildarolya3189]

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

[@ExcelDestination]

Sorry sir vimal ji nahi rahe

[@diya2909]

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

[@ExcelDestination]

Thanks for watching! there is another tutorial uploaded by me for preventing duplicate entries in excel using vba code. I hope that will help you. Link is : kzbin.info/www/bejne/r4G4dKtvfbmJrNE

[@diya2909]

Dear sir...it is not working...if I am using target sheet then it is not working...if I give use single sheet then it is working...sir if you don't mind then please give a code with taking the reference of this video.

[@diya2909]

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.

[@souravsarkar16]

Dear Sir, I will require help in that.. Please help us..

[@Muzaffareng]

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

[@ExcelDestination]

for any vba project, you can write to [e-mail]

[@chsaddam]

Excellent

[@ExcelDestination]

Thanks

[@coolag74]

Very Good...

[@josharouna]

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

[@royokinawa]

What if you want to modify data on the worksheets?

[@ExcelDestination]

you can watch another tutorial for that at following link : kzbin.info/www/bejne/q4ivoXh6n7iSZpI

[@DSureshKumar]

Perfect.

[@ExcelDestination]

thanks

[@DSureshKumar]

@@ExcelDestination sir i have two option button. One is Dr. And second is Cr. And for only one textbook I have. Now I want to entry data as per next row... How to do it.

[@verky56]

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

[@ExcelDestination]

let me check , if I have this file.

[@ttaMLowe]

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

[@rcmizohranglung7609]

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

[@naveedasghar3022]

hi Hranglung have u got solution for what u asked ?

[@sandip01_11]

Sir, How Can i add listbox in this userform?

[@naveedasghar3022]

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

[@aaravalan1355]

I guess it is kinda off topic but do anyone know a good site to stream new series online ?

[@yaelwallace8965]

@Aarav Alan flixportal :P

[@aaravalan1355]

@Yael Wallace thank you, signed up and it seems like they got a lot of movies there :D I appreciate it !!

[@yaelwallace8965]

@Aarav Alan No problem =)

[@hariomgupta4677]

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

[@ExcelDestination]

that would require different code. If you need this code for your project. Please send me email at [e-mail] Thanks!

[@ruposhibanglatec6767]

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

[@ExcelDestination]

You can try by defining variable also. Cell Reference is easy in case you don't have programming background.

[@bisiflora]

thank you so much for this

[@sunilpant2339]

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

[@ExcelDestination]

I can not tell you where is the issue, you can send me your file at [e-mail]

[@VeasnaThiv]

hello sir how to search from sheet1 and sheet2

[@ExcelDestination]

You can check another UserForm tutorial for Search, Display and add data. Link is given below : kzbin.info/www/bejne/eGWTXqmco7uUncU

[@RJMKJey]

Thanks bro

[@ajaymourya7775]

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

[@ExcelDestination]

Yes, you can

[@nikhillodhiya]

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 ?

[@ExcelDestination]

you need to add code for two sheets. process is same.

[@nikhillodhiya]

Codes also same ?

[@nikhillodhiya]

@@ExcelDestination sir I did it same codes and same process but results is just data transfar only one sheet can't transfer to both sheets

[@nikhillodhiya]

@@ExcelDestination because maybe userform is reset automatically when combobox1 selection sheet transferred right sir ?

[@nikhillodhiya]

@@ExcelDestination sir can you please make a video of what i said ? please.. because i tried many times and also searched in youtube and also Google but not find any videos of what i want... please make a video for me if its possible 🙂

[@vilaskamble2098]

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

[@ExcelDestination]

without looking at your code. can't say anything. You can send me email at [e-mail]

[@karimhati4318]

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

[@GauravSharma-zx6ih]

Press Alt + F11 Go to Insert Click userform

[@crazyfunnyvideo6477]

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

[@mukhlisbuneri]

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

[@ExcelDestination]

let me check, if I have the original file. Pls. send me email at [e-mail]

[@alijahangir712]

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

[@FaizurRahman00]

Worksheet(Targetsheet).activate

[@alijahangir712]

@@FaizurRahman00 its not a gramer error its a logical error

[@FaizurRahman00]

Share your complete code,

[@alijahangir712]

@@FaizurRahman00 plz give me whatsapp no i will send u snapshot of the error

[@ExcelDestination]

you need to use Worksheets("TargetSheet") instead of Worksheet(TargetSheet)..........there may be more error......however by looking at the line, I can say only this.

[@alializadeh8195]

Thanxx

[@reeteshism]

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.

[@lalitpatil5375]

SUBSCRIPT OUT ERROR WHAT CAN I DO

[@casper3842]

Not working when protected.

[@ExcelDestination]

This is very simple. I am not sure, why it is not working for you. For Protected sheet, you need to unprotect your sheet through vba then it probably works.

[@sangmeshwarkhurpe5109]

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.

[@stefanventer6356]

Hi, did you get an answer? I have the following problem and hope you might be able to assist. I have followed the coding however, when I run the code, I get an "Application-defined or Object-defined error". I need help with this and would appreciate if someone can assist me

[@georgethanos1661]

@@stefanventer6356 Declare the variables after the line: Private Sub CommandButton1_Click() . dim TargetSheet as string, lastrow as long

[@mafrazilyas]

@@georgethanos1661 kindly can you explain.... in my case debug this line "lastrow = ActiveSheet.Cells(Rows.Count, 1).End(x1up).Row" I don't know what is wrong here....

[@georgethanos1661]

@@mafrazilyas Hi, I am not in front of a pc..declare the variables "dim lastrow as long"..the code is End(xlup). I cannot distinguished if you write it correct

[@mafrazilyas]

@@georgethanos1661 that was L instead of 1! Thank you so much for the help!

[@skpatelgamingriderking7200]

Sir Pls make a update,delete,view commond button

[@skpatelgamingriderking7200]

Sir Pls make a update,delete,view commond button