: Visual Basic ( ) Project Explorer Insert -> User Form. (Form designer), ( UserForm1) Toolbox, .
( <F4>), . ( Click) <F7>, <Shift>+<F7>.
, , .
( ShowModal, ):
(Name) . , , . ( Visual Basic). , (UserForm) - , ( );
Caption ( ). , (, " ");
Enabled False, . , , - ;
ShowModal True ( ), , . VBA6 .
, .
:
( Visual Basic) <F5>. , , . Show():
UserForm1.Show
, , ( Load).
, , :
, ;
( AutoExec Word);
, (, CommandButton) ;
|
|
Open Word Excel, .
, / , . :
( Hide()), :
UserForm1.Hide
, . Show() , "", , , , , . .
, Unload:
Unload UserForm1
(Copy(), Cut(), Paste()), (PrintForm(), Repaint(), Scroll()).
VBA . (event) -, . , , , , .. VBA , , (event-driven). .
:
Initialize ( ). , , , ..
Click ( ) DblClick . . ( CommandButton). .
Error , . , .
Terminate (, Unload). , , .. (, End), .
, , ( )/ ( ).
, Initialize. , .