0.1 Working with UserForm By the userform
------------------------- we can create the custom dialog.
1) Activate the editor (ALT + F11)
Now press the button insert userform
or too ...
I could right click on any object in your project as (ThisWorkbook, or a leaf)
* and created our form we can perform a number of customizations agree
to taste or convenience. Normally
wish to change the name to identify it more simple ..
To access the properties for this object useform selected in your project and press "F4" can now
manipulate the properties.
rename the Usf_example1 sgte BackColor
in deployment options and choose a color.
another serious initial details how to hide or show the form
Now insert a module and place the code sgte
Sub call_form ()
Usf_example1.Show 'show the form End Sub
De
Similarly you can hide or download the form of a
sgte
'Unload Me' unload download .. use me ... if the code is in the form
* now close your form and go to the code editor to
This example first ShowModal to change the property Sgte false and run the macro line by line (press F8 while the cursor on the macro call_form1) Sub
call_form1 ()
Usf_example1.Show 'show form
Usf_example1.Hide' hide
Usf_example1.Show 'show
Unload
Usf_example1 'download the form. from a Sub End Module
