Scoping a Subroutine

A subroutine can be Public or Private. Public subroutines can be called by any subroutine in any module. The default for any Sub procedure is Public. A Private subroutine can be called only by other subroutines in the same module. To declare the subroutine Tasks as a private subroutine, use the statement 

VBA provides two built-in dialog boxes for display of messages or for input, MsgBox and InputBox. 

The MsgBox dialog box allows you to display a message, such as Please wait... or Access denied . The box can display one of three message icons, and there are many possibilities in the number and function of buttons that can be displayed. 

MsgBox (prompt text, buttons, title text, helpfile, context) 

The value of buttons determines the type of message icon and the number and type of response buttons it also determines which button is the default button. The possible values are listed in Table 14-6. The values of buttons are built-in constants — for example, the value 64 for buttons can be replaced by the 

---