How to transfer data from a user form to multiple worksheets in a workbook in Excel using VBA

Our Excel training videos on KZbin cover formulas, functions and VBA or macros. Useful for beginners as well as advanced learners. New upload every Thursday.
For details you can visit our website:
www.exceltrainingvideos.com/transfer-data-from-user-form-to-multiple-worksheets-in-excel-workbook-using-vba/
In this vide we show how we can quickly and easily transfer data from a user form to multiple worksheets in a workbook in Excel using VBA.
We have already learnt how to create multi-pages on a user-form:
kzbin.info/www/bejne/nGKsi6t4g9GfmpY.
For more knowledge read the book Excel 2016 Power Programming with VBA: amzn.to/2kDP35V
If you are from India you can get this book here: amzn.to/2jzJGqU

[@AlexVideoProductions]

Dhanyavaad!!, Sir, your videos are very good. I have been using Excel for a long time, mostly with formulas, tables, pivot tables and some macros, but never used Forms. Now with your tutorials I have learned many things that I will put in effect very soon. Thank You.

[@Exceltrainingvideos]

Alexis Delgado Thank you!

[@wayneseymour1]

Sir !! you are no going to believe what the problem was all along!!!! the type face ....??? my key board I guess don't know. all I did was at first copy and paste the code changed the things I needed to change but never noticed this your " " are different than mine, the error 9 started to move down the code the more I clanged the quotation marks...(weird) all I did was to retype the code parts that were causing it and WA LA!!!! works great. THANK YOU SO MUCH!!!!!!! F for your patience and guidance Thank you!!!!!!!

[@Exceltrainingvideos]

I've mentioned this in many of my videos and on my website: www.exceltrainingvideos.com/about-ms-excel-training/

[@Nanzyz1969]

I cant believe, how intelligent you are.. Sorry by my english, I'm from argentina. Best regards, and please not leave the videos!!

[@Exceltrainingvideos]

Thank you!

[@azhadshamim3122]

Your video always great to learn easily Thank you so much

[@prakashmayyak9916]

Beautiful explanation. Thank you very much sir. I'm continuously watching these videos.

[@aswathmyadam]

Dear dinesh sir U r tutorials r very useful for us thanks to share. Sir can i transfer data from user form to multiple work books pl. Share how it can be

[@Exceltrainingvideos]

Yes, you can. You need to open the workbooks, transfer the data, close the workbooks with 'savechanges' set to true. First try with one workbook.

[@aswathmyadam]

@@Exceltrainingvideos sir I tried with one work book it's working when I am trying with multiple work book i am unable to select workbook i am unable to open 2nd work book pl. Share the code . I am accepting 2 fields data from form based on this 2 inputs i want to open workbook and sheet in that work book and I want to transfer data to that work book. So pl share code for that

[@sandrasigma5978]

Great video !!! Very well explained. Thanks for posting. I have one question : How do you search into muliple sheets like the one in this tutorial, using a textbox in a userform and displaying the results in a multi column listbox?

[@Exceltrainingvideos]

These links will guide: www.exceltrainingvideos.com/tag/how-to-fill-text-boxes-with-data-automatically/ www.exceltrainingvideos.com/copy-paste-multiple-rows-of-data-from-one-workbook-to-another-using-excel-vba/ www.exceltrainingvideos.com/display-data-in-listbox-based-on-combo-box-selection/

[@jesseblattstein8574]

Dinesh, wonder if you could help with something. Is there a way to record a macro that pulls variable data (different text each day) from a certain cell and then go inside a table with filters and choose the pulled data from the checkboxes inside the table and return the pertinent info? Thanks.

[@udaykiran6752]

Thank You, Sir. Its really useful and I find very convenient listening to you and parallel creating a one for my use.

[@codalisa007]

Great teaching. Everything was explained. Thank you.

[@Exceltrainingvideos]

You are welcome. Please share with your friends also to spread the knowledge.

[@jaylilee1]

hi Dinesh, sorry again for asking for many question because i'm learning to do some userforms. regarding your video above, It is the code clicking one button and send data from userform to many different worksheet. For me, I want to transfer data from userform to many different worksheets but I want to have many buttons. example like I use userform multipage. page1 with different textbox and 1 transfer button. page2 different textbox with 1 transfer button, outside of the multipage I have other textbox in userform area . I do this because in my every worksheet I have same name of product, but I want to transfer different time of input. I can run the first page, but when I work in the second page and run it error " Run-time error '2110': "Cant move focus to the control because it is invisible, not enabled, or of a type that does not accept the focus." Please help

[@willsmith789]

Hello, awesome video. Do you know how to get from a listbox (persons) if multiple selection every selection (and only one selection) on a new row + add the date and a text (a task, the same task for every person) to every row ? Thank you.

[@SHAMIMFAYSAL]

Great video. I have learn a lot too from your other tutorial too. On that I also develop a tool like update data in multiple worksheet. Can you please help me how can I update data from master worksheet to respective supplier workbook. So that I have individual workbook for each supplier.

[@dominiquemeeks7496]

Great video! Is there a way to write code such that: if the last row is greater than 20 then a message box appears and data is not transfered? So that only the range A3:A20 will populate?

[@Exceltrainingvideos]

Dominique Meeks Just loop from row 2 to 20!

[@ТООИнновационныйцентркачества]

Dear Sir, thank you for your videos. i am learning to code in VBA Excel. i created database like in this video, but in database there are some calculations. when i enter the 0, database gives an error "6", overflow. and the calculate is ended. because in formula i must to divide by 0...could you please help me?.. and how can i add if, then to this VBA code like in your video? sorry for my english, thank you

[@asaduzzamandaria8731]

Thank you sir for this video and sharing excel-vba file.

[@Exceltrainingvideos]

You are welcome.

[@researchitechindia]

a good and nicely narrated about excel macros . Good to see your channel .

[@gdorman619]

Hello. Would you please be able to tell me how to list and set custom share point properties for excel files that are on a Share Point using VBA? For example when I created SharePoint library I added custom properties such as Reviewed? , Remediation Complete? and IAM Accepted?. These properties can be set on SharePoint for each file. I want do this using VBA. Thanks!

[@madhusudhan5384]

Hello Sir, My self Madhusudhan , I am working in some manufacturing company as a senior data entry specialist and my major task is entering the employees personal details along with the professional details of different teams. And I am searching for the method where I can enter the above details in main sheet (Sheet1) along with the different sheet i mean (Sheet2 -A1 Department, Sheet3-A3,Sheet4-A4) so that sorting get easier. So I found your user form video and I am really impressed by this user macro video, I need little more help like I need user form in sheet1 and if I click A1 department button in user form and enter transfer button the data should move to A1 (Sheet2) department sheet along with main sheet (Sheet1). Can I get this format of user form so it will help us in real time and reduce more time. RegardsMadhusudhan J

[@Exceltrainingvideos]

What code have you written (tried)?

[@madhusudhan5384]

Dear i have tried with the below code , and i am unable to edit the data when ever i click search and amend a new data is adding in same sheet which is duplicate of previous,Private Sub CommandButton1_Click() Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("Data")'find first empty row in database iRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, _ SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1'check for AID If Trim(Me.TextBox1.Value) = "" Then Me.TextBox1.SetFocus MsgBox "Please enter AID" Exit Sub End If'copy the data to the database 'use protect and unprotect lines, ' with your password ' if worksheet is protected With ws ' .Unprotect Password:="password" .Cells(iRow, 1).Value = Me.TextBox1.Value .Cells(iRow, 2).Value = Me.TextBox2.Value .Cells(iRow, 3).Value = Me.TextBox3.Value .Cells(iRow, 14).Value = Me.TextBox4.Value .Cells(iRow, 10).Value = Me.TextBox5.Value .Cells(iRow, 30).Value = Me.TextBox6.Value .Cells(iRow, 11).Value = Me.TextBox7.Value .Cells(iRow, 31).Value = Me.TextBox8.Value .Cells(iRow, 13).Value = Me.TextBox9.Value .Cells(iRow, 33).Value = Me.TextBox10.Value .Cells(iRow, 15).Value = Me.TextBox11.Value .Cells(iRow, 34).Value = Me.TextBox12.Value .Cells(iRow, 9).Value = Me.TextBox13.Value .Cells(iRow, 27).Value = Me.TextBox15.Value .Cells(iRow, 14).Value = Me.TextBox11.Value .Cells(iRow, 8).Value = Me.TextBox14.Value .Cells(iRow, 35).Value = Me.TextBox16.Value .Cells(iRow, 32).Value = Me.cbomarg.Value .Cells(iRow, 29).Value = Me.cboblood.Value .Cells(iRow, 12).Value = Me.cboemer.Value .Cells(iRow, 4).Value = Me.cbodept.Value .Cells(iRow, 5).Value = Me.cboloc.Value .Cells(iRow, 6).Value = Me.cbodes.Value ' .Protect Password:="password" End With'clear the data Me.TextBox2.Value = "" Me.TextBox3.Value = "" Me.TextBox4.Value = "" Me.TextBox5.Value = "" Me.TextBox6.Value = "" Me.TextBox7.Value = "" Me.TextBox8.Value = "" Me.TextBox9.Value = "" Me.TextBox10.Value = "" Me.TextBox11.Value = "" Me.TextBox12.Value = "" Me.TextBox13.Value = "" Me.TextBox15.Value = "" Me.TextBox11.Value = "" Me.TextBox14.Value = "" Me.TextBox16.Value = "" Me.cbomarg.Value = "" Me.cboblood.Value = "" Me.cboemer.Value = "" Me.cbodept.Value = "" Me.cboloc.Value = "" Me.cbodes.Value = "" Me.TextBox1.SetFocus End SubPrivate Sub CommandButton2_Click() Unload Me End SubPrivate Sub CommandButton3_Click() row_number = 0 Do DoEvents row_number = row_number + 1 Aid_in_Review = Sheets("Data").Range("A" & row_number) If Aid_in_Review = TextBox1.Text Then TextBox2.Text = Sheets("Data").Range("B" & row_number) TextBox3.Text = Sheets("Data").Range("C" & row_number) TextBox4.Text = Sheets("Data").Range("N" & row_number) TextBox5.Text = Sheets("Data").Range("J" & row_number) TextBox6.Text = Sheets("Data").Range("AD" & row_number) TextBox7.Text = Sheets("Data").Range("K" & row_number) TextBox8.Text = Sheets("Data").Range("AE" & row_number) TextBox9.Text = Sheets("Data").Range("M" & row_number) TextBox10.Text = Sheets("Data").Range("AG" & row_number) TextBox11.Text = Sheets("Data").Range("O" & row_number) TextBox12.Text = Sheets("Data").Range("AH" & row_number) TextBox16.Text = Sheets("Data").Range("AI" & row_number) TextBox13.Text = Sheets("Data").Range("I" & row_number) TextBox14.Text = Sheets("Data").Range("H" & row_number) TextBox15.Text = Sheets("Data").Range("AA" & row_number) cbodept.Text = Sheets("Data").Range("D" & row_number) cboblood.Text = Sheets("Data").Range("AC" & row_number) cbodes.Text = Sheets("Data").Range("F" & row_number) cboemer.Text = Sheets("Data").Range("M" & row_number) cboloc.Text = Sheets("Data").Range("E" & row_number) cbomarg.Text = Sheets("Data").Range("AF" & row_number) End If Loop Until Aid_in_Review = "" End SubPrivate Sub UserForm_Initialize() ' Comboxes listcboblood.List = Array("A+", "A-", "B+", "B-", "AB+", "AB-", "O+", "O-") cbodept.List = Array("Aviation", "Equine", "Fine Art & Specie", "Marine", "PRTC", "Crisis mgt") cbodes.List = Array("Process Specialist", "Senior Process Specialist", "Associate consultant", "Assitant Manager", "Deputy Manager", "Manager", "Delivery Head") cboemer.List = Array("Father", "Mother", "Husband", "Wife", "Others") cboloc.List = Array("Bangalore", "Gurgoan") cbomarg.List = Array("Single", "Married")

[@Ramp10er]

Does the worksheet updates when you input another data? I'm creating a user form that has Add/Save, Edit/Update and Delete...

[@ahmadjutt77]

But Sir I Have One Question If You Have Three Sheets And Your Paymnet Is not Clear So you dont Want To Transfer Data In 3 Sheet And Later When It Is Cleard It Is Automatically Transfered TO The Third Sheet By Just Changing The Transaction Status Form "In Progress" To "Cleared"

[@MIS4Tech]

Hi, Mr. Kumar, Great! Very helpful , thanks for posting.

[@danielhabteyes8327]

Great tutorial! Thanks

[@Exceltrainingvideos]

Glad it was helpful! Please share with your friends too.

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

[@Exceltrainingvideos]

Query not clear.

[@Ramp10er]

Dinesh! To replace a code much faster create a module insert the code that needs replacement, then press F3 to find and replace the word/letter/numbers you want to replace immediately. After you have replace all that you need erase the module... Just Copy and Paste...

[@sallu21m]

how do i transfer the data to only one page out of three pages for invoice no and invoice dt with balance pages remaining blank???

[@wayneseymour1]

Hi Sir how can I get this equation into excel?3600s/hr x 3cy x .85 /20s x 50min/60min x 1/(1+35) the answer should be 283.3 bcy/hr. I cant seem to get it to calculate Its a Excavator Productivity formula, thanks by the way for your solution to the calendar, all of this ties into a multi age form that you tutored on I'm taking the amounts placing them in the form then sending them to a spread sheet. IFollowed your lesson on the multi page form but now i need to enter this formula in vba to complete the project thank you sir for all your advice and help over the years.

[@Exceltrainingvideos]

This lesson link will guide: www.exceltrainingvideos.com/using-custom-formula-in-excel/

[@wayneseymour1]

@@Exceltrainingvideos Thank you sir

[@muraliiyer7850]

Very good learning.

[@Exceltrainingvideos]

Please share with your friends on facebook and twitter. Thanks.

[@muraliiyer7850]

@@Exceltrainingvideos i want to learn more. Can i hv your mail id.

[@brooklynkeen3810]

I have this same set up but not different tabs on the userform. Is there a way to put the same information from the userform to 2 different spreadsheets?

[@Exceltrainingvideos]

Brooklyn Keen This video might help: www.exceltrainingvideos.com/transfer-data-from-user-form-to-multiple-worksheets-in-excel-workbook-using-vba/

[@AToolsPro]

+Brooklyn Keen share excel for multiple user on LAN, internet atoolspro.com

[@I--es5ln]

Great video But sir how to tranfer data from one userform to another permanently for invoice in userform Pls reply🙏🙏

[@Exceltrainingvideos]

Query not clear. What's your goal and what have you tried/

[@I--es5ln]

@@Exceltrainingvideos Sir I just wanted to know that how to transfer data from one userform to another userform in combobox for invoice so that is I select the customer's name the details related to that automatically generates in userform I have tried to make a billing software In that is someone wants to add a new customer so he will the new customer and then that data should be permanently saved in invoice userform in combobox so that he selects that person's name and the details related to that automatically generates that I need So also u don't understand so pls contact on this no: 9004683223

[@funvanity]

Good day sir. can you please help me to create code, i do really try to look for the code but i cant make it. ] here's the situation. if i select my year(BSEcE1A) using combobox, the input data on textbox1 will copy on sheet1 and sheet2. then if i select my year(BSEcE2A) using combobox, the input data on textbox1 will copy on sheet1 and sheet3. the sheet1 represents as my log and sheets2&3 are the designated year level. Thank you and God Bless you sir. hope you would gonna help me.

[@jubrajsushari9129]

Sir I need your help - can we pass textbox data between two userform ? If yes please help me .

[@Exceltrainingvideos]

Create 2 userorms userform1 and userform2. In the userform1 place a textbox and a command button control. In userform2 place a textbox control. For the command button control in userform1 use the following code: Private Sub CommandButton1_Click() UserForm2.TextBox1.Value = TextBox1.Value Unload Me UserForm2.Show End Sub

[@Exceltrainingvideos]

Where are you applying this solution?

[@tarundhingra8660]

Can we also add data in specific location like specific worbook saved somrwhere ~

[@Exceltrainingvideos]

First you'll have to open the specific workbook as shown in this link: www.exceltrainingvideos.com/copy-data-to-another-excel-workbook-based-on-criteria-using-vba/ You can now transfer data to the required worksheet as shown in this linl: www.exceltrainingvideos.com/tag/transfer-data-from-user-form-to-worksheets/ Or search www.exceltrainingvideos.com

[@ahmadjutt77]

Thx Sir Its Very Great And Useful

[@rnodern]

A few suggestions. Why don't you use a naming convention for your text boxes? (like txt_Blah, txt_Yada) That way you can cycle through all of the controls with a For Each loop and you catch all the ones starting with "txt_". Better yet, you can setup a lookup array of all of your text boxes and where they should go. That way your code is just 4 lines to cycle through the array which will do all of that.

[@fredakissi6698]

Thank You Dinesh and thanks for your quick responds, My problems is; i want to call an item in a combo box with a button, edit it and send BACK to the SAME ROW. Please help me.

[@Exceltrainingvideos]

This link will guide: www.exceltrainingvideos.com/create-manage-database-in-excel-with-user-form/

[@fredakissi6698]

Thank you with your help, i have done it thank you soooo much

[@xlintips1920]

Hi! I have 3 four Sheets in which states and party names are existing. I wish to use count, sum, function from all the sheet in one sheet summary. pls. help.

[@Exceltrainingvideos]

www.familycomputerclub.com/what-every-microsoft-excel-user-must-know.html

[@FairDealMarketing]

Great Dear

[@Exceltrainingvideos]

Thank you! Cheers!

[@DavidSiddiqui]

sir if i want to make search and update button in this user form then how i make

[@Exceltrainingvideos]

This link will help: kzbin.info/www/bejne/nKbLc6uFeL5nldE You can search this cannel or www.exceltrainingvideos.com

[@suryakantyakkarnall5408]

Sir Great learning could you please teach How get back these multiple worksheet back on to Userform, edit and save it. Thanks Y.Suryakant

[@sreenathcherry5705]

Hello Sir, I used the same code as you have used but am getting an error at line "lrCD = Sheets(“CustomerDetails”).Range(“A” & Rows.Count).End(xlUp).Row" as Subscript out of range....please help me too to solve it.........

[@Exceltrainingvideos]

Sreenath Cherry Are you writing the code, using the sample file or copying & pasting the code? www.exceltrainingvideos.com/transfer-data-from-user-form-to-multiple-worksheets-in-excel-workbook-using-vba/

[@sreenathcherry5705]

I have used the same code as you have used ,still the same prob

[@Simple0987654321]

+Dinesh Kumar TakyarHello, I am getting error information same with Sreenath Cherry, but the code 100% same with your code. Could you please, help me deal with the problem?

[@Test_yourknowledge]

Sir Our sheet is the value of combobox.We want the name of the employee whose sheet we select in the combobox to appear in the equal text box. And Sir, can we solve your problem by mailing you

[@Exceltrainingvideos]

The link to this Excel VBA tutorial will help: www.exceltrainingvideos.com/tag/fill-text-box-controls-with-data-from-worksheet-based-on-combobox-selection/ Or kzbin.info/www/bejne/pWGvo2eBedOsapY No guarantee of help via email but I always try!

[@Test_yourknowledge]

@@Exceltrainingvideos sir Thanks for sending the link And sir you are really great man

[@jadadocs8844]

Hello, thank you for the awesome videos. I need some help in creating a customer database in excel. I would like see all the products purchased by an individual by clicking on a customer number. I would like to be able to add more products to the same customer without retyping their personal details. Something along the lines of clicking to select the customer from the list which will show only that customers details and their product history and next service date. I would appreciate if you have any videos or information for me. Await your reply. Many thanks.

[@Exceltrainingvideos]

Search www.exceltrainingvideos.com You'll find a number of solutions to your query.

[@karijesionowski503]

Thank you for your post it was very helpful.

[@viktorijabarkauskiene343]

Hi Dinesh! Your videos are very helpful and easy to follow. I tried to make my own userform with multiple pages and used parts of your code. I can't seem to make it work. I keep receiving the message "Subscript out of range (Error 9)". I have 3 multiple pages with 3 textboxes each. This is my code: Private Sub CommandButton1_Click() Dim lrCD As Long, lrPD As Long, lrS As Long lrCD = Sheets(“SFAREN”).Range(“A” & Rows.Count).End(xlUp).Row Sheets(“SFAREN”).Cells(lrCD + 1, “A”).Value = TextBox1.Text Sheets(“SFAREN”).Cells(lrCD + 1, “B”).Value = TextBox2.Text Sheets(“SFAREN”).Cells(lrCD + 1, “C”).Value = TextBox3.Text Sheets(“SFAREN”).Cells(lrCD + 1, “D”).Value = TextBox4.Text Sheets(“SFAREN”).Cells(lrCD + 1, “E”).Value = TextBox5.Text Sheets(“SFAREN”).Cells(lrCD + 1, “E”).Columns.AutoFit lrPD = Sheets(“NORR”).Range(“A” & Rows.Count).End(xlUp).Row Sheets(“NORR”).Cells(lrCD + 1, “A”).Value = TextBox1.Text Sheets(“NORR”).Cells(lrCD + 1, “B”).Value = TextBox2.Text Sheets(“NORR”).Cells(lrCD + 1, “C”).Value = TextBox6.Text Sheets(“NORR”).Cells(lrCD + 1, “D”).Value = TextBox7.Text Sheets(“NORR”).Cells(lrCD + 1, “E”).Value = TextBox8.Text lrS = Sheets(“KUPOLEN”).Range(“A” & Rows.Count).End(xlUp).Row Sheets(“KUPOLEN”).Cells(lrCD + 1, “A”).Value = TextBox1.Text Sheets(“KUPOLEN”).Cells(lrCD + 1, “B”).Value = TextBox2.Text Sheets(“KUPOLEN”).Cells(lrCD + 1, “C”).Value = TextBox9.Text Sheets(“KUPOLEN”).Cells(lrCD + 1, “D”).Value = TextBox10.Text Sheets(“KUPOLEN”).Cells(lrCD + 1, “E”).Value = TextBox11.Text End Sub Private Sub UserForm_Initialize() TextBox1.SetFocus TextBox2.Text = Date End Sub I was wondering if you could help me understand what the problem is, thank you very much! Any help is appreciated :)

[@Exceltrainingvideos]

This link will help: www.exceltrainingvideos.com/how-to-use-multipage-control-on-userform-in-excel/

[@viktorijabarkauskiene343]

Thank you very much for your help, it was very giving. The trouble I am having right now is that I do not want textbox1 and textbox2 to show on all my sheets everytime. Depending on what multipage I am on I want all the information on that specific worksheet, not all of them, like yours is. You have invoice nr and date showing on all sheets I want them only on the multipage/sheet I choose. So multipage1 should show information on sheet 1 and multipage2 on sheet2 and so on. So textbox1 and 2 are login names and date and pages are different rooms with customers. I am grateful for your help. Thank you very much!

[@fredakissi6698]

Mr. Dinesh, I have made a "Delete" buttun out of your data management program, but when i delete the last data i send into the database, it deletes every thing in the database

[@Exceltrainingvideos]

To learn more visit www.exceltrainingvideos.com

[@duniafatamorgana2558]

How to input excel table to web page ? Thank you dr..

[@safahussain4768]

hi sir it's very use full for me , but I need if I enter any item 2 time exp for customer x take 12 and y take 5 in the med I need to calcutae to gather 17 pcs plz help me in this regard

[@apenforastone5768]

pp

[@nishantkumar9570]

Thank you very much. Could you please help me writing to code for the putting the hartford data to an excel table which expand automatically instead of just ti sheet. How to reference table in vba. Thank you once again.

[@Exceltrainingvideos]

This link will help: www.exceltrainingvideos.com/copy-table-data-to-new-worksheet-with-vba/

[@nishantkumar9570]

Thank you, Sir

[@paramesgopal841]

Hi sir I want excel data transfer to word but I was any change to excel sheet the data is store to next page to word automatically

[@fredakissi6698]

How can i deduct a quantity being sold from a stock quantity?

[@zmeme-9]

Thanks alots for good workd sir

[@Exceltrainingvideos]

Keep watching

[@jaylilee1]

hi, I can transfer data from userform into excel, but he information still in my userform. I want to add another info and transfer data, but it overwrite it in excel . how to solve?

[@Exceltrainingvideos]

Hlubkoj Tsispaubtag Check out this link: www.exceltrainingvideos.com/transfer-data-from-user-form-to-multiple-worksheets-in-excel-workbook-using-vba/

[@jaylilee1]

hi Dinesh, now it works. I want to know one more thing how can the textbox automatically blank after I click the transfer button? I want specific textbox to be blank after I press transfer. Also how to set the "Enter" in keyboard to work if I enter then the transfer button work?

[@Exceltrainingvideos]

Hlubkoj Tsispaubtag Have a look at these links: www.exceltrainingvideos.com/add-code-to-user-form-controls/ www.exceltrainingvideos.com/add-code-clear-cancel-command-buttons-on-user-form/

[@jaylilee1]

thanks Dinesh. 1. How can I set specific textbox to clear or be blank after I have transfer the data? 2. how can I assign a button in excel to open the userform I created? very appreciated your teaching

[@AToolsPro]

+Hlubkoj Tsispaubtag share excel for multiple user on LAN, internet atoolspro.com

[@Simple0987654321]

Thanks you very much.

[@blindsniper9657]

Hi, Good day! I wanted to know if any of your course would help me to solve the problem I have on excel, mainly I want to make multiple worksheets and when I make some data entry on worksheet 1 it will go to a specific worksheet. (example: Ryan jay - toyota Yaris - 600,000 - 12/12/2016) inside on it, that will be a name of the client, brand, amount, and date it was purchased for that it will go to the Toyota worksheet, and with so on with another brand of Toyota's. And again the same guy order another car but a different brand and it was Honda and that will go on the other worksheet for Honda . and another guy name Julius order the same Toyota Yaris and this go along with Ryan under the worksheet of Toyota. lastly, a worksheet with all the data generated even Toyota or honda or any car it will have a report of all sales for each month that I have to make collections.

[@Exceltrainingvideos]

www.exceltrainingvideos.com/create-summary-sheet-sort-data-vba/

[@blindsniper9657]

thank you sir

[@ngocjangkim4458]

Sir, I would like to download this file for studying. Pls give me the link to download it!

[@Exceltrainingvideos]

www.exceltrainingvideos.com/transfer-data-from-user-form-to-multiple-worksheets-in-excel-workbook-using-vba/ Alternatively, you can do a search at exceltrainingvideos.com

[@ngocjangkim4458]

I can't see it here..... pls show me!

[@matthewdpeterson1738]

Please help! If you do not add data to one of the sheets, how do you keep from adding blank lines? I tried setting my workbook up with this code, but I have some sheets that I don't add data to every time. How do I keep the sheets I don't add data to from adding blank lines?

[@brookematthews9717]

Matthew D Peterson I have same question. Please share solution if you have received feedback.

[@matthewdpeterson1738]

Brooke Matthews, I figured out that you have to place an enter button on each page. Code each page with the code to enter the data on that particular page. (sheet1, sheet 2, etc.). Hope that helps. Happy Thanksgiving! Let me know if you have any more questions or that doesn't make sense.

[@awhitmire238]

On your If Then statement you need to create a separate line that includes Else If = " " then do nothing or allow to progress to the next step without including any information.

[@virenderkamra2414]

How do transfer data from excel to Govt web site such SS administration or Dept of Revenue web site?

[@Exceltrainingvideos]

Search www.exceltrainingvideos.com Also read the website's guidelines.

[@stubbornjatt69]

Sir, using the code above I m getting subscript out of range error. Please help

[@Exceltrainingvideos]

Check your worksheet names and count.

[@trandominhkhoi]

Thanks Sir.

[@Exceltrainingvideos]

Welcome! Please share my channel goo.gl/5Jx1NP with all your friends. Thanks.

[@ashiqhussain2371]

How can we add data in a password protected posting data file using userform and how can we protect file from being deleted

[@Exceltrainingvideos]

This link will help wrt protected worksheet; www.exceltrainingvideos.com/run-vba-code-macro-on-protected-sheet/ The trick is to unprotect the worksheet before data transfer and protect the worksheet again after the work is done.

[@mizouman]

very useful , thank you

[@nickignatiadis4958]

How do you split data to separate worksheets by customer name

[@ClaudiaDeyulia]

Awesome! Thank you

[@hanumantsinghrana9244]

सर जी नमस्कार क्या आप छोटे छोटे साफ्टवेयर बनाकर भेज सकते हैं

[@ChAzGamr]

Hi Dinesh Me Again and still going crazy. I need your help. I am still trying to copy data ( a row at a time or textbox from a UserForm) to 2 different workbooks. The main "WorkBook1" has the UserForm and "WorkBook2" Has only the info pasted to it.This is what I have: Private Sub EnterMasterBTN_Click() Dim LastRow As Long LastRow = Sheet1.Cells(Cells.Rows.Count, "b").End(xlUp).Row Sheet1.Range("b" & LastRow).Offset(1, 0).Select ActiveCell.Value = ActiveCell.Offset(-1, 0).Value + 1 Sheet1.Range("b" & LastRow).Offset(1, 9).Value = Now() Sheet1.Range("b" & LastRow).Offset(1, 1).Value = OperatorTBX.Text Sheet1.Range("b" & LastRow).Offset(1, 3).Value = PalletNumberTBX.Text Sheet1.Range("b" & LastRow).Offset(1, 5).Value = RollNumberTBX.Text Sheet1.Range("b" & LastRow).Offset(1, 7).Value = WeightTBX.Text Sheet1.Range("b" & LastRow).Offset(1, 11).Value = NotesTBX.Text ' here is where I need to enter it into another workbook ' J:\RouteSheet.xlsx is WORKBOOK1 ' J:\MonthlyTotals.xlsx is WORKBOOK2 Workbooks.Open Filename:="J:\MonthlyTotal.xlsx" ActiveSheet.Select ' The Next Line is where it stops Sheet1.Range("b" & LastRow).Offset(1, 0).Select ActiveCell.Value = ActiveCell.Offset(-1, 0).Value + 1 Sheet1.Range("b" & LastRow).Offset(1, 1).Value = OperatorTBX.Text Sheet1.Range("b" & LastRow).Offset(1, 2).Value = PalletNumberTBX.Text Sheet1.Range("b" & LastRow).Offset(1, 3).Value = RollNumberTBX.Text Sheet1.Range("b" & LastRow).Offset(1, 4).Value = WeightTBX.Text Sheet1.Range("b" & LastRow).Offset(1, 5).Value = NotesTBX.Text ActiveWorkbook.Save ActiveWindow.Close MsgBox "One PALLET entered" response = MsgBox("Do you want to enter another PALLET?", vbYesNo) If response = vbYes Then OperatorTBX.Text = "" PalletNumberTBX.Text = "" RollNumberTBX.Text = "" WeightTBX.Text = "" NotesTBX.Text = "" Else: Unload Me End If End Sub Any Sugestions Thank you

[@Exceltrainingvideos]

ChAz Gamr ActiveCell.Value = ActiveCell.Offset(-1, 0).Value + 1 Is -1 OK?

[@ChAzGamr]

Dinesh Kumar Takyar Thank you I will try it. Again Thank you

[@ChAzGamr]

Dinesh Kumar Takyar Tried it and it still stops there and the line before it. Thank you

[@gracegbamou476]

HOW CAN I GET VIDEO ON HOW TO CREATE MULTIPLE USER ENTRY FORM

[@Exceltrainingvideos]

This Excel tutorial will help: kzbin.info/www/bejne/pKTIeKNji9Oli8k

[@gracegbamou476]

Thank you sir

[@gracegbamou476]

I need the process to build multiple user form using combo box

[@gracegbamou476]

The one you build to transfer data in 3 sheets

[@gracegbamou476]

I need the process where you click shipping and customer from the form the boxes uses and how to do it

[@hophonglan]

Thank you so much

[@SuperHanme]

thank you Takyar

[@Exceltrainingvideos]

Glad the VBA tutorial was helpful. Please share with your friends also on social media.

[@saddamhossin1283]

Sir how to multipage data search and update.

[@Exceltrainingvideos]

This Excel VBA lesson will help: kzbin.info/www/bejne/nGKsi6t4g9GfmpY

[@saddamhossin1283]

@@Exceltrainingvideos sir i can not search and update here./this video. Pl new video upload.

[@ahmadjutt77]

I hope You Understand My Question And Will Reply SoonThankyou Very Much

[@wasimbader9170]

thank you, got that, regards

[@AbdulGani-ws3pp]

sir how to add two check box in this userform

[@Exceltrainingvideos]

Abdul Gani Please have a look at these videos:@show-hide-user-form-controls-using-check-box/@using-check-box-control-on-excel-user-form/

[@sunilthakur3230]

Thankyou

[@goyaltraders3265]

User foam ko banate waqt label Ka font Ka size kaise increase

[@vinodkumarbhasin]

thanks sir

[@mdr7283]

Great Video... question is it possible to have a userform that retrieves information from excel? example, the excel sheet has the name and tel. no if i enter the name John Smith on the userform the form would then give me his phone number

[@mdr7283]

im using excel 2007

[@Exceltrainingvideos]

Have a look at the details here: www.exceltrainingvideos.com/how-to-update-excel-worksheet-records-with-userform/

[@mdr7283]

thanks sir...please keep doing your videos it has helped me do my work efficiently!

[@azharsayed6600]

how to add date in combox

[@Exceltrainingvideos]

Search www.exceltrainingvideos.com or my KZbin channel.

[@goyaltraders3265]

Userfoam me font size kaise increase Karen label me

[@goyaltraders3265]

Sir 1 video banakar show

[@Exceltrainingvideos]

Right-click on the label. Select properties. Click next to font and do the needful.

[@AnwarAlfaqeehAlhusseini]

hi How to transfer data from a user form to multiple another workbook in Excel using VBA

[@Exceltrainingvideos]

Try this: Use the command button to open the relevant workbook and then transfer the data to that workbook's sheets.

[@AnwarAlfaqeehAlhusseini]

thanks >>>i will try

[@gypsies0184]

I keep wanting to zoom out so I can see all the code!

[@Exceltrainingvideos]

This link will help: www.exceltrainingvideos.com/transfer-data-from-user-form-to-multiple-worksheets-in-excel-workbook-using-vba/ Alternativel do a search at www.exceltrainingvideos.com

[@kaizenhuang8769]

the last row dont work

[@Exceltrainingvideos]

This link will help: www.exceltrainingvideos.com/transfer-data-from-user-form-to-multiple-worksheets-in-excel-workbook-using-vba/ You can also search www.exceltrainingvideos.com

[@tubpheejteblauj4828]

You mentioned that the VBA Code will be available on the website, but you do not provide the link to your website. How do we access it? Thanks!

[@rcppfeedback]

Good but not working in excel 2007

[@arpraveenkumar9078]

just give ur contact for more enquires

[@rajapurplace3853]

Can you do me a favour

[@fredakissi6698]

How can i deduct a quantity being sold from a stock quantity?