Input and output in VBA

Most programming languages will contain commands that enable the user to input data from the keyboard and output results on the monitor display. Of course, data could be input and displayed by using worksheet cells in Excel. However, this may not be appropriate for it might be necessary to input or output without using worksheet cells. A function is defined as something in VBA/Excel that will return a value and will be familiar to any Excel user. Functions will be studied in more detail in Chapter 9. VBA for Excel supports two built-in functions for the primary purpose of input and output. They are InputBox and MsgBox.

0 0

Post a comment