Using Input Box

The built-in function InputBox can be used to both send a message to the user and to obtain data from the user without it appearing in a worksheet cell. Consider the example  

A box pops up on the worksheet with the quoted prompt and a place for the user to type in the value requested (in this case, for the variable a). 

Example Program 2.5 Using MsgBox and InputBox for Input/Output 

Another version of the example program for finding the average of a list of numbers is shown below. In this case, MsgBox and InputBox are used for input and output. Note that three consecutive quote marks are required for one quote mark to appear. 

Dim InpatNuiibcr As Double a number Stained from the spreadsheet Dim Ntafiombers As Integer the number of nombers in the list 

---

In sections 6.11 and 8.9 we encountered a rather special case of convolution involving the function 1/Vi. A macro to perform this operation was used in section 6.11, and is listed below. It uses input boxes for the data spacing (in time) and the measured currents, then calculates the convolution of that current with 1 /Vr. 

---