Userforms MS Excel

[@MyAudioBookCompilation]

As I recall this is the first channel that taught me and gave me more interest in excel that was 7 years ago. Thank you so much sir.

[@Exceltrainingvideos]

Great to hear! You also have a good channel: Make It Happen With Excel

[@arendvandam3067]

I was able to create a well-working input form with only your video. Thanks a lot for the very clear explanation!

[@Exceltrainingvideos]

Thank you. Please share with your friends and on social media. You can view more videos in Hindi and English at www.exceltrainingvideos.com/

[@jakeh3144]

You're an Excel Wizard! I'm definitely coming to this channel for help with future projects. Thanks!

[@barsahudson3976]

Thanks Dinesh, Tutorial has been so interactive and educative, i have managed to create my first userform, i also used the code to clear the combo box, and it worked.

[@ViswanathanM]

Very nice diction using simple and clear language. Thanks a lot for explaining a very important aspect of data filling.

[@kezzays]

Thank you very much for your series of Excel tutorials. It's been very useful to my daily work and tasks

[@brandihinnant]

Thank you so much for breaking it down. Especially the coding part which can be tricky!

[@zuhaibmzk]

Great Dinesh sir. thank you a lot. This video is my first intro to VBA. May Allah increase you in Knowledge.

[@creativeart6786]

Thank you Mr. Takyar, your videos are very helpful and easy to understand. I thank for your patience to describe so softly to make it more easier to understand for a beginners. .......Vikash

[@justinkollam]

Very nice presentation and easy to understand. Thanks

[@deanthomas1588]

I have watched the Userforms MS Excel tutorial and it works great, you explain things very well. What is the next tutorial to move on from this?

[@Exceltrainingvideos]

If you wish to learn VBA step by please visit this link: www.exceltrainingvideos.com/excel-vba/excel-2003-vba/ Or search www.exceltrainingvideos.com

[@AlSedge]

really useful - had been a while and loved the new features, much easier than used to be to create forms! Thanks

[@liviuvoica8700]

Dinesh! Your tutorial is awesome! I like it and it worked like a charm. I like you sincerly, your patience in your voice made me learn very fast and asimilate all this information. I subscribed to your channel. I wish you a very nice day.

[@Exceltrainingvideos]

Liviu Voica Thank you!

[@haristeo1964]

1000 Thanks sir .I have promplem with textbox in userform with text and numbers format and i find solution in your VBA code

[@jbdtg]

Dear Sir, Many thanks for the post! Explanation was clear and complete! I was able to complete my task for an assessment!

[@Myfif1983]

Really thank you for this video. wish you all the best

[@cannoguz]

You've prepared a very nice course. m really thanks a lot. I can not find a nıce Turkish lesson. I subscribed to your channel. I wish you a very nice day.

[@suzimac1780]

Thank you Danesh- very clear and well explained

[@wahbafarah5715]

many thanks for this valuable & detailed explanation. I really enjoy it.

[@prakashmayyak9916]

Great explanation. Thank you very much.

[@indian3197]

Excellent video. Sir can i create a dashboard using userform to view excel data. pls suggest

[@heyehification]

This is exactly what I was looking for. Thanks alot

[@jomipurayidam]

Excellent Lecture. Thank You

[@mihindurajaratne4190]

Good one indeed. Thanks. Presentation is enticing me to try it

[@habbeja]

Very Good! Thank, for helping me impress my boss! Great work.

[@Lucream2]

Thanks very much sir, you really tought me what I needed to start my excel forms, but what if I want to edit/ delete some data using the form?

[@Exceltrainingvideos]

User Forms can work both ways. Have a look at the video 'Advanced UserForms' or Userform to Interact with Worksheet Excel VBA.

[@Lucream2]

Thank you once more, do you have an online coarse, where students can learn and get a certificate for programming?

[@Lucream2]

I mean learn, write exams and get a certificate

[@danicequeabeah7856]

Thanks. for this nice tutorial. I still need to view this video and take some note.

[@markbrazzeal6443]

OMG!! I love this tutorial! Only one thing that needs to be clarified is 100% more is the erow programing. I have been all over the net trying to figure out why it wouldn't work for me. Come to find out that the eRow = Sheet1.Cells(Rows.Count, 1).End(x1Up).Offset(1, 0).Row doesn't work if you put a number1 in the (x1Up).offset part. It's not a number 1 but a lower case L as in l. The font being used makes a number 1 and a l look almost identical! I hope this helps anyone else

[@ErnestNiiAmartey]

mark brazzeal Thanks Mark, i nearly gave up, but your finding relieved me

[@zuhaibmzk]

Thanks Mark Brazzeal. I also almost going to giving up but thank you.

[@brendasmith4623]

Hello Dinesh, I am learning from your videos. I have begun my form project but I can not get the tab to go in the correct sequence in the text boxes. It should go from left to right in order but it sometimes skips boxes. It is important that it goes in the right order. Do you have suggestions for this?

[@Exceltrainingvideos]

Brenda Smith Watch this video carefully: www.exceltrainingvideos.com/focus-on-control-on-excel-user-form/

[@faceformers]

This was so helpful! Thank you so much!!!

[@jamesbuffon79]

Thanks, great tutorial. Exactly what I was looking for

[@mohamedborhan113]

Great Post . Excellent Job. God Bless you

[@poojatawale8902]

thank you sir for your such a informative videos.

[@Exceltrainingvideos]

Check whether all your variables are defined if you using the latest versions of Excel like 2010 or 2013.

[@thebesttechnical3608]

Very useful information nice video

[@Exceltrainingvideos]

Appreciate your feedback. Please share with your friends and on social media.

[@rpatel143]

Could you please advise: How to autofill other textboxs based on one entry from past data enter in the userform? Thank you in advance

[@jibyjacob7]

Well explained. . Good job...

[@theycalmemrtils]

GREETINGS. Thank you for your excellent videos. I watched several. I am having difficulty writing a code that performs the find the next empty row function only for a specific range. not a whole column. meaning i want the userform to find the next empty row between, row 4 and row 24 for example...i can't seem to figure out how to write this code....could use your help. Thanks in advance

[@eviirawan48]

Thank you very useful video.

[@smvd3k]

Question: how do you clear the combo box? (see 18:45 of your video). Its a very useful video, thank you by the way.

[@kehdi22]

Thank you! Great video!

[@PraveenRajKumarYx]

Hi Dinesh, Good day to you! I have a requirement to develop an application in Excel VBA. I have some VBA coding knowledge so that is not the actual problem. My problem is how to run this application, as an application like an exe file or so. The only way to run my application is to open the Excel file, go the Visual Basic Editor and Click Run (or press F5). I don't need this way of running the application. Aren't there any other possibilities? Could you please help me with this? Thanks in advance!

[@salammollik7628]

good morning Dinesh sir I have fascinating to see ur video tutorial here can u send me any good link ur site

[@spannas1]

Hi, I found your tutorial very useful, but i cannot get the code for the command button to work. I have followed your lesson to the letter, but i cannot get the command button to submit the txt value onto the worksheet. Do i need a different code for MS Excel 2007?

[@ShivaKumar_Bheemasena]

Hello Sir, Thank you for the video, however I have one question that how to make user form available to update by multiple users simultaneously and save the data on next line without getting error

[@Exceltrainingvideos]

Have a look at these links: www.exceltrainingvideos.com/capture-data-from-userform-to-excel-worksheet/ www.exceltrainingvideos.com/transfer-data-from-user-form-to-multiple-worksheets-in-excel-workbook-using-vba/ Or do a search at www.exceltrainingvideos.com

[@brendanjames9791]

Good video, thanks for the info

[@kwasidiaw]

Please how do I get the transcription of this presentation? thank you

[@2310partha]

Dear Sir, Thank you very much for the detailed explanation. I want use the same data entered in User form in two different sheets. Further I want the user form to be capturing basic details of an invoice such as: 1) Invoice number ( Drop down Combo box) 2) Customer Name ( Drop down Combo box) 3) Amount 4) Currency 5) DATA 1 6) Data 2 7) data 3. So Once the above is entered in the user form it should go to the invoice format in a new sheet. like this i will be raising 50 invoices to different customers so 50 sheets i the same format.Once done I shall give a print command for all invoices to print. Is it possible. Thank you

[@Exceltrainingvideos]

Watch this video: kzbin.info/www/bejne/bmbamqubdpqgmaM If you want the data to go to sheet2 then add sheet2 before the Range. Pls give feedback asap. Thank you!

[@tamimitakrim5678]

Hello sir, did erow actually need to assign with something first to work ?why i try your code from video "How to capture data from userforms into excel worksheet"and got error 1004 where it stated Application-defined or object-defined error.

[@taixueqian]

you are great! Million thanks~!

[@Sallu0123]

sir could you please help in the below error i created userform name, price and product and combobox. for the yellow color let me know correct code wat i have to write Cells(Erow, 1).Value = txtname.Text Cells(Erow, 2).Value = Val(txtprice.Text) Cells(Erow, 3).Value = txtProduct.Text Cells(Erow, 4).Value = cmbcode.Value

[@AbdulRasheed-ex4nb]

i am getting an error while setting up the row source invalid property value plz help with thanks i also thanks for your theaching methed so nice

[@Exceltrainingvideos]

Question not clear.

[@GoldenBearAlum2012]

Hello Sir, I'm trying to create a userform for mass data entry. The user form has only two textboxs for data entry which are filled by the use of a bar code scanner. Instead of having to press a command button to log the information is their a way to code the userform to auto log, then clear the information automatically once the two textboxs have been filled?

[@Exceltrainingvideos]

You can try to use a timer...

[@yuri040776]

Hello, Can I create Excel user form to check/stop/start Windows server services?

[@fuzzywuzzy66]

I couldn't find the rowsource in my form. Is it called differently in mac version?

[@mopecvideos7172]

Hello Dinesh, the video was helpful but in Office 2013 I keep getting a run error 424 on the first line of the code for the transfer.

[@harinderpalsingh3474]

hello sir, can i make an invoicing program using excel? basic requirements are auto serial no. generation, date, item description etc. can i do it through a data entry program in excel? need your help n advice.

[@Exceltrainingvideos]

harinder pal Singh Helpful link: @create-invoices-using-template-with-userform-in-excel/

[@suraj1747]

Dear sir, I have make some extra mark ledger with marksheet in excel but i want to fill up all the roll no., name, marks in form how can i use form in the excel sheet by using design tool...

[@Mukminmelayu]

How do you create a command that adds the data onto the worksheet where new data entry will always be at the top and with the order that the oldest data will always be at the bottom?

[@ngnews24-tv13]

Please how can I retrieve Information from SQL Server using an exel form. Any tutorial or advise would be helpful. thanks

[@jrbr549]

Help!!!! I got to the part where my userform appears on open, but my sheet 2, which contains my lists, opens behind it. Is there a way to make it so the first page where I want my data stored opens instead?

[@jrbr549]

Nevermind, I got it!

[@deepibmt]

i am getting an error while setting up the "ROW SOURCE"--- invalid property value.. could you plz help

[@Nilofer76]

in sheet 2 i wrote the numbers but i m unable to see or that in command buttom.... can u help....

[@poojatawale8902]

I just finished with my VBA course but I am unable prepare any macro. could you please help.me with looping

[@Exceltrainingvideos]

www.exceltrainingvideos.com/calculations-using-loops/# www.exceltrainingvideos.com/nested-loops-excel-vba/ www.exceltrainingvideos.com/loops-for-next-excel-vba/# You can also search www.exceltrainingvideos.com

[@poojatawale8902]

Dinesh Kumar Takyar thank you sir

[@mystiquemarvel3255]

I would like more of an explanation on the eRow code that you created, you skipped over the last line of code a little fast as I am getting errors of mismatching and also it just not making sense. Thank you for the rest of the tutorial tho,

[@Exceltrainingvideos]

Search www.exceltrainingvideos.com/

[@justferfunny]

Thank you.

[@ndidiceciliaokorie7176]

great! I am creating an excel database of work instructions and I don't want to use the userform. what do I do?

[@Exceltrainingvideos]

Input your data directly into the worksheet - give a good thought to the data arrangement.

[@ndidiceciliaokorie7176]

Alright. thanks so much.

[@mohamadchaaban7712]

Hi Sir the macro is working very well for me in terms of technicality. But i still have a problem. the first cell i want to be checked is C10 not A1. The macro keep filling A1,A2,A3,.... Can you help plz?

[@Exceltrainingvideos]

If you're using the cells property in a loop then cells(i,1) will access Range("A1") if I=1 Cells(I,3) will give you Range("C10") if I=10.

[@mohamadchaaban7712]

thank you

[@mohamadchaaban7712]

I have one more question. is it possible to start a userform (userform 2) once you exit another userform (userform 1)? if possible would you explain for me with the code plz? thank you

[@Exceltrainingvideos]

Private Sub CommandButton1_Click() Range("A1") = TextBox1 Unload Me UserForm2.Show End Sub

[@mohamadchaaban7712]

works like a charm! :))) i was looking over the internet for a trick in regards to updating a table using userform. the userform update data in sheet 1. on the other hand, there is a table (table formatting) on sheet2 (calculation sheet) , this table contains all the data entered in sheet 1 and calculate different ration. this table in sheet 2 (calculation) is not updated automatically :(

[@sairatmatkal]

dear sir,i had done all the procedure but i cant able to transfer the data from userfiorm to excel.

[@jaskaransandhawalia5577]

Thanks

[@decarr8969]

Thank you

[@BalwinderSingh-rc7xp]

how to excel userform data enter into excel sheet table format?, Sir pl. reply me

[@coreyrussell649]

I keep getting an error message (Invalid outside procedure) and the 1 after Offset is highlighted. What is the solution?

[@Exceltrainingvideos]

Check your assignment for erow thoroughly. erow = sheet1.Cells(Rows.count, 1).End(xlUp).Offset(1, 0).Row

[@bahramkhoshnaw9520]

nice ... good

[@aiyeshakausar6901]

hi sir, I am new to macros. I am trying to save the macros and reopen it. but macros is not getting saved. please help. thrice I tried.

[@Exceltrainingvideos]

www.familycomputerclub.com/excel/training/calculations-macro.html : at around 3.5 minutes the video shows how to save a macro enabled excel file.

[@kamrul28]

Thanks yousir how to upload photo in userform can you make video for us

[@AmitSharma-po1zb]

Hi Sir, I'm facing an issue with the userform I created. Whenever I run my userform, it is closing all other opened excel workbooks. Pls help me to solve this.

[@Exceltrainingvideos]

Can you share your code?

[@bhanuprakash2264]

Dear Sir, Hello ,mene excel 2013 32 bit me software banaya hai agar me usse excel 2013 64 bit me run kar raha hu to compile error aa raha hai. to usse kese compile or run karenge . Thank You

[@Exceltrainingvideos]

Check out these links: answers.microsoft.com/en-us/msoffice/forum/all/convert-excel-files-from-32-bit-to-64-bit/91652c3f-0d3c-4e02-a9bb-c82263538cae docs.microsoft.com/en-us/office/client-developer/shared/compatibility-between-the-32-bit-and-64-bit-versions-of-office

[@markrogers1152]

Thanks for sharing your knowledge. I have tried to follow but am having a problem with the code. Private Sub cmdtfrdata_Click() 'Range("A2").Value = TxtBox1 'Range("c2").Value = Firstname 'Range("b2").Value = Lastname 'Range("d2").Value = emailtxtbox 'Range("e2").Value = Phoneno 'Range("f2").Value = regions erow = Sheet11.Cells(Rows.Count, 1).End(x1Up).Offset(1, 0).Row Cells(erow, 1).Value = TxtBox1.Text Cells(erow, 2).Value = Lastname.Text Cells(erow, 3).Value = emailtxtbox.Text Cells(erow, 4).Value = Phoneno.Text Cells(erow, 5).Value = regions.Text Cells(erow, 6).Value = membertype.Text End Sub I receive the following error: Run-time error 1004 Application-defined or subject-defined error. I would appreciate the help on this!

[@Exceltrainingvideos]

Mark Rogers Is it TxtBox1 or TextBox1? You may need to use Worksheets("Sheet11").Cells(Rows.Count, 1).... Check all the variable names used.

[@markrogers1152]

Thanks! Yes I needed to use the worksheet 11

[@EventHorizonTV]

Whenever I remark out the ranges the transfer doesn't work. The transfer button only works when it's not remarked. Also when I enter my "erow" code I keep getting *Run-Time error '424'* Object Required. the coder highlights yellow, don't know what's wrong.

[@EventHorizonTV]

+EventHorizonTV Typing the erow exactly: erow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row

[@Exceltrainingvideos]

+EventHorizonTV What's your sheet's name? Sheet1? Have you 'dimmed' erow like so: Dim erow as Long

[@EventHorizonTV]

+Dinesh Kumar Takyar Yes I named the sheet that i'm working in "Sheet1" just like the example. I entered in the code *Dim erow As Long* but I still get the run-time error. Everything is entered exactly as it is in the video. I don't know whats wrong.

[@EventHorizonTV]

+Dinesh Kumar Takyar Also, when I right click on "Cells" and then definition it says"identifier not recognized." Perhaps that's the problem?

[@Exceltrainingvideos]

+EventHorizonTV Show me your code.

[@TheRottendude]

Hi, A small suggestion... It would be great if the videos are short and quick.. Students often do not have the time to sit down and watch the entire length... Just quick clicks here and there instead of lengthy explanations.. :)

[@jakeh3144]

The video is a bit lengthy yes, but it's very thorough. Other lessons may be able to be recorded quickly, but something like VBA and using the code associated is getting into the more advanced, difficult excel applications.

[@aneep123]

doesn't work when i run it,i get "run-time error 424: object required"

[@helloimranbd]

nice

[@ishwarpadhanparmanpursanto2283]

By using user form create purchase inventory

[@Sallu0123]

if anyone knows please help me in the below issue

[@captcardwell3398]

"Frm for form" lol bros out here trying to save 1 letter xD

[@charstubble]

Great video tutorial. Here is a resource for Mac users trying to use rowsource in a form: support.microsoft.com/default.aspx?scid=kb;en-us;175795

[@NTCco]

could you talk any slower?

[@ilovemyindia20msubscribers58]

which version of excel it works