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.