Excel VBA Bundle (2 Books): Excel VBA and Macros and 51 Awesome Macros by Philippe A. Louis

Author:Philippe A. Louis [Louis, Philippe A.]
Language: eng
Format: azw3
Published: 2018-02-21T16:00:00+00:00

9 UserForms

The UseForm is an awesome and useful tool, what provides an easy way for your applications interact and get information from the user. The forms also uses the same objects from Chapter 5 - ActiveX, but forms also uses other elements that was not previously shown, because these others elements are useful for Forms.

For create a UseForm, you just need to access your VBA editor (Alt + F11) and then navigate to Inser > Userform.

When you add a form, automatically your useform window appears at the right, than you can customize the form by adding the objects with the ToolBox. If your Toolbox isn't visible, be sure to click the UserForm. It's visible when the UserForm is selected. You can also activate the ToolBox by clicking View > ToolBox.

Note: Select the object UseForm1 and press F4 to display the form properties. The most important properties are:

Name – Change the VBA object name

Caption – The caption name at the top of the window

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.