.


:




:

































 

 

 

 


4.

VBA. .

1. .

2. Microsoft Excel, .

3. .

4. A1:A9 .

-

5. A1:F1 .

6. , , , .

7. .

8. Properties :

Name cmdCheckIn
  Caption
Name cmdSearch
  Caption

9. VBA. - - VB.

10. . Insert - Module.

11. , , . , , .

, VBA, . :

12. , - . , - .

, VBA, 1( ) . :

13. .

ü (Insert - UserForm), (Label), (TextBox), (Frame), (ListBox), (OptionButton), (CommandButton) (Calendar) (. 1).

ü Tools - Additional Controls. . 11.0. . .

.1. .

14. Properties :

Name frmReg
(CommandButton) Name cmdSave
  Caption
(CommandButton) Name cmdCancel
  Caption
(CommandButton) Name cmdDelete
  Caption
(Label1) Caption
(TextBox) Name txtLastName
(Label2) Caption
(TextBox) Name txtFirstName
(Frame) Caption
(OptionButton) Name optMale
  Caption
(OptionButton) Name optFemale
  Caption
(Frame) Caption
(Label3) Caption

15. . View Code.

16. . (Insert - UserForm), (Label), (TextBox), (ComboBox) (CommandButton) (..2)

.2. .

17. Properties :

Name frmSearch
  Caption
(CommandButton) Name cmdSearch
  Caption
(CommandButton) Name cmdCancel
  Caption
(CommandButton) Name cmdEdit
  Caption
(Label) Caption
(TextBox) Name txtLastName
(Label) Caption
(ComboBox) Name cboFound

18. . View Code.

19. . , . - 15 . .

..3. , . .

.3. .



<== | ==>
 | : қ - ү ңғ қ .
:


: 2017-03-11; !; : 312 |


:

:

, ,
==> ...

741 - | 735 -


© 2015-2024 lektsii.org - -

: 0.014 .