Wax Job Before And After

--------------------- Working with userform



Add controls to form


To add controls to your form using the toolbox. If the toolbox is not visible, choose View, Toolbox in the VIEW menu

can agrgar its controls by clicking the control and then dragging the form or you can click on the control and then to click on the section of the form where you want to insert.

Each time we add a control given the name of control over numerical sequence indicator

for example every time we add a label .. the first will be the second label2 label1 .. .. .. so clear that he
be possible to rename the controls more convenient names

To change the name of a controlled must select the control ... go to properties window and choose the

property name and assign the name you want. Some controls


------------------
Label (label) : This will show a text control within

useform Text Box (TextBox) allows the user to enter text

Combo (ComboBox) : allow contain a list of items but only show a while to be deployed. Table

List (ListBox): Displays a list of items which user you can select from one or more.

Checkbox (CheckBox):
are useful when the user needs to specify several options. The check box is checked the value of true.

button (OptionButton). be employed where possible uan choose one option among many.
When a button is activated (true) the other buttons will be disabled. Control

image (Image). is used to display an image from a file or loaded from the clipboard.

RefEdit. will allow the user to select a range of cells.

To identify the controls in the toolbox just Sit on some control and a label will appear with the name of control.

Cartman Join Nambla Clown Hat Clip

0.2 0.1 Working with







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

GetSaveAsFileName