Great and very helpful 👍👍👍👍

Its great people like this that fuel the education system

Sir, thanks a ton for such useful video. I really appreciate your training videos and your calm and composed approach throughout the video. In this code which you have used for clear code, it is practically not working for dropdowns as it is messing up the tab. For e.g if i have a dropdown field and enter a value, on pressing , it is not moving to next field.

Thank you for for evrytheng

Thank you

thank you for all of this sir

Dear sir, thank you very much

Thanks ... Thanks ... Thanks

thanks

Dear sir, thank you very much. But i have a question. İf there is a combobox, how can use that codes?

Very clear and easy to understand the way you do explain codes. i want all of my text and dropdown boxes filled if not error msg will appear and data will not transfer to excel sheet. thanks in advance

Dear Mr. Takyar to say that you are Nr One in teaching on line maybe an understatement. Definitely the Best.... Now if you could also do a lesson on: How to make command buttons to high-light when cursor passes over them. Will be an added to me privilege. Thank you so much Sir.

Hi. Why in the cmdAdd code you don't close the next-loop right after the first comparison? In the code you wrote for each time the next-loop goes the program makes three comparisons (3 x i comparisons), but just one is needed per cycle and once it ends then check whether count is 1 or not (i + 2 comparisons)..

Hi Dinesh, your tutorials are really amazing and well explained. I need help about a data which I applied duplicate prevention to allow me to exempt not to apply the duplicate proof on specific names, not cell or range based in both excel or VBA. Let say I want to be able to enter Jason as much as I want but not the other names. I would really appreciate it if you could help Sir. Thanks Jason

does not work with numbers in first column, i put words in first column and it works, but it will not error for duplicate numbers ie serial numbers

Dear Sir, Could you please suggest us the link/videos how to share the macro enabled (user form) file so that multiple user can access the workbook simultaneously , since soon i try to share a macro enabled file all macros are disappearing from the file. Please suggest us. Regards

Have a good day.... May god bless u sir...... I am Balaji M Sharma from Tamilnad....Commerce Graduate and I am Doing my heredity profession like Prohit means Pandit in my village.... When I was working in Garments Co. as a Accountant we use to work in foxpro programmes salary and other accounts activities....After came of the job now i am looking after my traditional job at my own village.... in the meanwhile i use to file GST returns for around 50 dealers in and around my village.....The Dealers use to give their purchase bills from 100 to 300 nos every month... Then I have to Calculate Tax wise Gst Amount and according these value the remaining return procedure will be done.... there i use data entry userform for each dealer to enter their purchase bills... Initially it is very difficult to me to work later i use to see your vba coding videos .....I my self create my own data entry from with help of your coding method and i am succeed with my work... now i can able to work easy and comfortable ... the whole credit goes to u..... I cannot say in words .... YOU are REALLY a NOBLE Person i never seen ever before Thanks a lot My dear Ji.......

Sir, is there any solution to get the top 10 value with name without duplicate value and name. Data pick from the columns

sir, I had a problem with clear code, but finally I had noticed that Imust type the typename exactly like this"TextBox" to run correctly, I would share this to help others

Sir kindly share codes for update button, i have gone through all your videos where u tried to explain it, but sorry to say sir none of these update codes work perfectly if used in multiple page userform. Plz share if it is possible

Thnx for ur helpful videos " please tell me how to select textbox automatically after adding data to sheet by entering " enter key" not using mouse or tab..... Plz do hurry it's very urgent for me

When i click on add button showing data add in sheet what i am doing now. duplicate entry couldn't define???????????

Dear Sir, I've create a userform following your video but facing some problem like duplicate entry couldn't define. And another problem is in update button. While pressing the update button then the update is being only in 2nd column. I would like to attach my created file for your kind reference and will seek for your kind help.

Sir Dinesh, good day...i hope you can help me for this, I do a practiced using your code in Inventory Management with UserForms video..and i like it...for now, i need a code that if I click the Add Button it will clear all that data in the userform and only the Order Number with new series will be retain..because in your sample if i click the Add Button the data was still there in the userform..I looking forward for you great replies on this...

can you share whole video for this tutorials?

hi thanks for nice explanation/ i have a question pleas / if i need to add a command botton inside the word document or templat and write a code for it that save the document as the NAME lable field (plain text content control), in a specific bath directory, how can i write the code pleas ? can you drope the line code that do this when i click in this command botton.? pleas your answe and thank you in advance.

sir if i input same numeric data on textbox1 it will still add.. how to fix this thanks

how to code the clear botton in visual studio 6.0 please I have project to pass on tuesday

Hi Dinesh, I'm not sure why but when I add the last row string I receive an error.lastrow = Sheet1.Cells(Rows.count, 1).End(x1UP).Row can you help me?

Hi, How can I contact you please,I need your help in coding if you don't mind.

having problem with i as variable not defined. I copied the code as it is.

क्या ऐसा हो सकता है कि टेक्सटबॉक्स की वैल्यू जिस सीट में जाए अगर हम टेक्स्ट बॉक्स पर कोई नाम दोबारा टाइप करते हैं तो ऑटोमेटिक नीचे सो करने लगे जैसा कि एक्सेल शीट में होता है जो नाम ऑलरेडी रहता है तो वह पुनः दिखने लगता है

Hi ,,,where is next part edit & delete ,,,,,I can't see please send link ,,,,,thanks a lot

hi again, I followed your video step by step, but it doesn't work

Sir please hindi me samjaiye

Second ;-)