This was excellent. So simple and your instructions were fantastic. I was able to fix my userform so it wouldn't allow empty boxes. I appreciate you.
@Exceltrainingvideos
2 жыл бұрын
Glad it helped!
@rodrigomendez1272
4 жыл бұрын
Big thanks from the Dominican Republic, Dinesh. Code is working like a charm for a Consulting project over here.
@Exceltrainingvideos
4 жыл бұрын
Glad the VBA tutorial was helpful! Please share with your friends also on social media.
@zulfikrimuhamad5908
3 жыл бұрын
Thanks Teacher. It is very useful
@Exceltrainingvideos
3 жыл бұрын
Glad to hear that. Please share with your friends too.
@chelebarry
6 жыл бұрын
Dinesh, I have always loved your videos you are very precise on your explanations. I have problem with regards to the topic at hand. I am using event handlers on multiple text boxes in my user form to avoid jumping to the next box before assuring the data in the first has been field. I saw in another tutorial a code place in the exit event and it works well, the issue is when I need to exit the form and click on my exit button, seems since after adding the data in the textboxes, copying on the designated sheet and clearing them for a new run when a click unload me the exit event active and the error message pops up again.Can you help me?
@Exceltrainingvideos
6 жыл бұрын
This link will help: www.exceltrainingvideos.com/ensure-all-data-fields-in-userform-filled-before-transfer-to-excel-worksheet-using-vba/
@chelebarry
6 жыл бұрын
I have seen it and there was some doubt I had. You use a sub to check blanks and I want to check as I go along the filling up of the form. I have my conditions clear but the focus is going out of the textbox I want.
@mohammedzafar8011
4 жыл бұрын
I find your videos very informative. Thank you for providing such easy to understand video lessons. Is it possible to print the userform with only the values in it without seeing the text box or combobox.? If yes how.?
@Exceltrainingvideos
4 жыл бұрын
What is the aim of doing such an action?
@mohammedzafar8011
4 жыл бұрын
First of all thank you sir, from the bottom of my heart for responding to my query. Sir be rest assured that I do not have any financial intention for raising this doubt. Neither this is my field of work nor do I have any such plans. I am on my verge of retirement and trying to make a better use of this lockdown. It is just a casual query as the printout of form was not as desired or any way near to the output of other forms. There we don't see combobox or text boxes. Keeping my fingers crossed.
@Exceltrainingvideos
4 жыл бұрын
You can work with the back-color and other properties of the controls to find a good solution.
@mohammedzafar8011
4 жыл бұрын
Thanks, I will try that.
@vikasgupta-jv6gs
6 жыл бұрын
Hi sir. Its so nice to have you on KZitem. Your videos are very helpful for me. Sir, i have executed this VBA code but i am facing a issue that is... When user form is open for entering data in it then at the same time i can't be able to orher excel files. Please help me out.
@razaulkarim7702
8 жыл бұрын
thanks for this video. do you have any userfrom for pharmacy inventory
@tarassamolyuk1659
3 жыл бұрын
can we also add success msgbox to verify successful submission ? How can the code be changed in that case ?
@Exceltrainingvideos
3 жыл бұрын
You can loop through the controls to check if the controls have a value. If yes, then give out the appropriate message.
@Allwyn77able
6 жыл бұрын
Dear Sir, I am a great fan of your videos, most of my VBA coding has been inspired by your videos. Thanks and keep posting. I have a query, I have created a form with two text box, one is name and the other one is address. I have put a condition to check if the length of text box1 is > 10. The code is working fine till here. I want the code to go back to text box1 till such time the len is > 10 In my case it shows the msg box which states that the len is less than 10 but goes ahead to textbox2 seeking input. Kindly advice on how to resolve this issue
@mehbubalam7228
7 жыл бұрын
Hi.. Thanks ffor the amazing video. But when I try to write the same code and i type "ctl." then the .value option is not appearing. I am using excel 2013. So could you please advise on what is the problem ? I have declared the ctl variable as well.
@yellakarikesavacharyulu9738
2 жыл бұрын
Sir Please present a lesson on Word Bookmarks for filling the repetitive information in Word Temlate
@Exceltrainingvideos
2 жыл бұрын
Sure I will
@VibeShiftChroniclesGA
9 жыл бұрын
hi, Can you please show, how to write VBA code for " If the certain specified cells do not contein data do not save the Excel sheet. Thank you
@ExcelMadeEasy444
7 жыл бұрын
Thanks ! How To use VBA Built In functions ?
@yburnitsuga
7 жыл бұрын
Thank you for this Sir!
@ralphvalladares1571
4 жыл бұрын
Im looking for some help creating a print command button that will print a completed form to a other sheet.
@Exceltrainingvideos
4 жыл бұрын
This link will help: social.msdn.microsoft.com/Forums/en-US/ed79771f-47ac-432c-b30d-5e9562ce2a63/vba-excel-printing-a-userform?forum=exceldev
@MrElnk
9 жыл бұрын
How do I search for an existing record and edit it using the forms?
@simonrutten7398
9 жыл бұрын
How can we check a group of Optionbuttons ?
@dipmoni1
6 жыл бұрын
Sir, how to create a sell register in worksheet with userform invoice generator.
@tusharshukla1990
9 жыл бұрын
typename(ctl) is not working for me it takes the values of textbox in the ctl variable
@tomasarana19
4 жыл бұрын
The Variable "CANCEL" is not defined. Compile error.
@Exceltrainingvideos
4 жыл бұрын
Dim cancel As Boolean
@Laxmanmane007
5 жыл бұрын
Nice
@Exceltrainingvideos
5 жыл бұрын
Thanks
@hassentouati77
8 жыл бұрын
HiPleas help mI creat my macros but Every time open my file excel i lost macros ....
@Exceltrainingvideos
8 жыл бұрын
+Hassen Touati You have to save your file as a '.xlsm' file.
Пікірлер: 37