Teach Microsoft Office
Online Video Tutorials for Microsoft Office
Request Tutorial
Excel Help and Consulting
Video Player Demo
User Testimonials
Easy to Follow and Great Content
Awesome tutorials. This is great work; thanks a lot for all of these tutorials, and at a great price. The tutorials are easy to follow and understand and are very valuable for me. Teachmsoffice.com has helped me a lot in terms of increasing my Excel skills and learning how to master Excel. Keep up the good work!
- Sarah M.

Thank you so much!
Thank you so much! My professor was giving me a hard time with this...so I told him I will just figure it out on my own and this site really helped me figure everything out!!
- Ms. R

Thank you and godbless
My text book really sucks and I'm very thankful that you have all of these tutorials. I finished my last two questions because of your site! Thank you and godbless.
- Rob V.

Amazing Videos
Just wanted to say that your videos are amazing. I'm watching them and they really help me understand. The way you explain and go through everything is amazing. Thank you soo much!
- Design X

Saved a Ton of Time!
You have just saved me so much time, I cannot thank you enough!
- L. J.

Thank You!
Thank you for sharing these important tips. Your voice is clear and the steps are clear. It is easy to follow. Thank you!
- Kent

Saved Me Time
Thanks for the tutorials, I never had to do this before today and I needed it done very quickly. These videos saved me time I didn't have!
- Mitchel S.

Thank You!
Thank you! Helped me so much!
- M. Clean

Excellent Tutor
I was just listening to the tutorial online and I must say that the tutor is doing an excellent job.
- D. B.

Sign Up to View Tutorials
Purchase Subscription

Automatically Close a Form After an Action Has Occurred

This Excel VBA UserForm tutorial shows you how to automatically close a UserForm after an action has occurred within the form. This action can be anything from the user submitting data through the form to the user saving data from the form and so on. Basically, you will learn how to programmatically close the UserForm at any time during the execution of code within the form. This will allow you to prevent data from being entered more than once because you can close the form after it has been filled out. This is a great tip for making your UserForms more user-friendly.
Tutorial Length (mm:ss): 5:00
Sign Up to View Tutorials
Purchase Subscription
Downloadable Files: Yes
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training close userform automatically after exit excel after action unload cancel
Bookmark and Share
View All Tutorials - 375 Tutorials - 36 hours 28 minutes of Content
Similar Tutorials
Tutorial Length
(mm:ss)
Office Program
Add a Combo Box (Drop Down Menu / List) to a UserForm in Excel 17:20 Microsoft Office Excel
Add an Entry on a New Line with a UserForm in Excel 13:15 Microsoft Office Excel
Run a UserForm from a Button in Excel 4:34 Microsoft Office Excel
Close an Excel UserForm 4:40 Microsoft Office Excel
Change the Title of a UserForm in Excel 4:14 Microsoft Office Excel
Change Button Text in an Excel UserForm 3:37 Microsoft Office Excel
Show the Excel UserForm Toolbox 1:50 Microsoft Office Excel
Add a Text Label to an Excel UserForm 4:34 Microsoft Office Excel
Display a Tip when a User Hovers Over an Element in a UserForm 4:00 Microsoft Office Excel
Left Justify Text in a TextBox within an Excel UserForm 2:41 Microsoft Office Excel
Limit Number of Characters that can be Entered into a Text Box in an Excel UserForm 3:21 Microsoft Office Excel
Separate VBA Code from the Excel UserForm 10:21 Microsoft Office Excel
Prevent Incorrect Values from Being Typed into a ComboBox in a UserForm 4:11 Microsoft Office Excel
Automatically Close a Form After an Action Has Occurred 5:00 Microsoft Office Excel
Change the Color of Excel UserForms and Controls 5:24 Microsoft Office Excel
Use a Picture as an Excel UserForm Background 5:41 Microsoft Office Excel
Get Values from Excel UserForm Controls 8:10 Microsoft Office Excel
Reset or Clear Values for Excel UserForm Controls 11:05 Microsoft Office Excel


This Excel UserForm tutorial shows you how to change the color of everything within a UserForm. You will learn how to change the color of a TextBox, ComboBox, ListBox, the entire UserForm, and anything else that you can put into a UserForm. Adding color to your UserForms is a great way to make them stand out or blend in with your worksheet and this tutorial explains everything that you need to know about it.
Tutorial Length (mm:ss): 5:24
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training color background userform controls excel button input text box list change
This Excel UserForm tutorial shows you how to set an image as the background for a UserForm. You will learn how to insert the image and how to change the position and resizing attributes of the image within the form. Also, this tutorial explains all of the steps that you need to go through in order to make a professional looking custom background image for your form. Doing this, you will be able to have professional looking UserForms.
Tutorial Length (mm:ss): 5:41
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training picture image userform background excel user form photo gradient professional picture photo
This Excel UserForm tutorial shows you how to get values from a UserForm. You will learn how to get the values that a user inputs into the controls within a form and then how to do whatever you need with those values. This includes getting the input from a Textbox, ComboBox, ListBox, CheckBox, OptionButton (Radio Button), and ToggleButton. Every step of this process is covered in this tutorial, including how to reference UserForm controls from within the UserForm or from within a separate VBA Module. In addition, this tutorial will cover the types of output that come from different controls within the UserForm.
Tutorial Length (mm:ss): 8:10
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training retrieve input values controls userform excel vba user form textbox combobox listbox text data use
This Excel UserForm tutorial shows you how to reset or clear the values for UserForm controls. You will learn how to reset all controls back to the default values as well as how to simply clear all input from the controls within the form. This means that you will be able to remove all text from a TextBox, selections from a ComboBox or ListBox, clear any CheckBoxes or OptionButtons, as well as reset ToggleButtons. This tutorial will help you prevent duplicate entries in Excel from the UserForm and will help to improve the overall UserForm experience.
Tutorial Length (mm:ss): 11:05
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training clear reset values controls userform excel delete remove textbox combobox listbox checkbox optionbutton togglebutton
 
Official PayPal Seal SSL
Join TeachMsOffice.com on Facebook
Follow TeachMsOffice.com on Twitter


Microsoft Office Tutorials | Office Tutorials - Excel Word PowerPoint | HD Tutorial Video Player Overview | About TeachMsOffice.com

TeachMsOffice.com provides HD Online Video Tutorials and Training for Microsoft Office programs such as Excel, Word, and PowerPoint. We use a specialized video player interface to teach a vast list of Microsoft Office Tutorials and we add new tutorials on a weekly or monthly basis.