Current location - Recipe Complete Network - Catering franchise - How to make an order system with excel
How to make an order system with excel
1. Create a new Microsoft Office Excel 2003 workbook.

2. As shown in the figure below, draw a 5*4 table in the workspace.

3. In order to be beautiful, it is necessary to adjust the column width and row height of the table to 20 and 30 respectively.

4. Enter the contents of the take-away order menu into the 5*4 table in turn.

5. Add an external border style to the 5*4 table.

6. Add the start and end buttons under the 5*4 table. Draw two boxes and add words and styles.

7. Select Tools = > Macro = >" Visual Basic Editor in the menu bar.

8. Double-click Sheet 1 in the editor to write the code as shown in the blank pop-up window.

9. Return to the workbook, right-click the Start button, and select "Specify Macro" in the menu bar. Then select "Sheet 1. Random "and click OK. Complete the specified macro of the end button in the same way.

10. At this point, a random order menu is completed. Click Start, and a box with a red background will be generated in the table, moving back and forth randomly.

1 1. Then, click Finish, and the box at the bottom of the red will stop in a grid. Ok, let's eat cucumber ham today.