The number of the receipt page and the product name are referenced by the data validity, so that we can easily select the input data. This can shorten the time for us to fill in the data as much as possible. VBA code is written by Excel, which realizes common functions such as calculation, saving and billing. Click on the menu bar: Development Tools-Insert, select the button plug-in, and then select the specified macro function with the right mouse button. In this way, we can give the control different code functions by specifying functions.