--------------------- 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.