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