Mediation. A settlement of a dispute or controversy by setting up an independent person between two contending parties in order to aid them in the settlement of their disagreement. In International Law, mediation is the friendly interference of one state in the controversies of nations.
User-Defined VBA Function & Sub Procedures. In Excel Visual Basic, a set of commands to perform a specific task is placed into a procedure, which can be a Function procedure or a Sub procedure (also known as functions and subroutines).
Public myGlobalVar As String. Click the Insert menu and click Module to insert a second code module. Add the following code to give the global variable a value: Public Sub defineVal(). myGlobalVar = this is a global variable. End Sub. Click the Insert menu and click Module to insert a third code module. Add the following code, call the sub-procedure that gives the variable a value, and display the variable value through a message box: Private Sub showGlobalVar(). MsgBox (myGlobalVar). End Sub. Click inside the showGlobalVar() sub-procedure, and press F5 to run the program.