Voorbeelden van het gebruik van End sub in het Engels en hun vertalingen in het Nederlands
{-}
-
Colloquial
-
Official
-
Ecclesiastic
-
Medicine
-
Financial
-
Computer
-
Ecclesiastic
-
Official/political
-
Programming
End Sub stubs for you.
Start the actual function End Sub.
End Sub Convert a table back to a normal range.
Individual code for error handling End Sub.
End Sub 2.9.3 Userform: move to another file.
Perform task during which an error may occur End Sub.
End Sub 2.9.2 Worksheet: move to another file.
Until it reaches the last line of code, that is“End sub”(B).
End Sub But these events only respond within that workbook.
All macros begin with Sub and end with the End Sub keywords.
End Sub In this case it's simple because it's a fixed time value.
Warning of unexpected error End If On Error Goto 0' Deactivate error handling End Sub.
End Sub Another method with which settings can be saved is by using the registry.
Applications dialog box opens, please paste following code between sub and End sub.
End Sub 5.3.6 Eventprocedure: copy A combination of reading and writng an eventprocedure.
paste the following code to the dialog locates between Subscan and End sub lines.
please copy and paste your own code without the Sub heading and End Sub footer between the If CarryOn vbYes Then
the procedure implementation is ended by the Exit Sub command not to be confused with End Sub.
please copy and paste your own code without the Sub heading and End Sub footer between the Sub Runcode() and End Sub scripts.
If you want to run the code while closing workbook each time, select Deactiviate from the right drop down list in the Code window, and copy the code you will run and paste between Private Sub Workbook_Deactivate() and End Sub.
Then copy your own code without the first and last line and paste between Private Sub Workbook_Open() and End Sub as below screenshot shown.
paste between the Private Sub and End Sub lines in the Code window.