Current location - Music Encyclopedia - Chinese History - Vba history
Vba history
In excel, when the operand changes, the operation result of the formula will also change.

Extended data:

Microsoft Excel is the software that Microsoft uses Windows and Apple? Spreadsheet software written by a computer with Macintosh operating system. Intuitive interface, excellent calculation function and chart tools, coupled with successful marketing, make Excel the most popular personal computer data processing software.

1993, after the release of version 5.0 of Microsoft Office component, Excel began to become the overlord of spreadsheet software on the applicable operating platform.

Microsoft Excel history:

1982, Microsoft launched its first spreadsheet software ──Multiplan, which achieved great success on CP/M system, but lost to Lotus 1-2-3 on MS-DOS system. This incident prompted the birth of Excel, just as the research code of Excel is Doug Klunder: Do what Lotus 1-2-3 can do, and do it better.

1985, the first Excel was born, which was only used for Mac systems. In June, 1987, 1 1, the first Windows Excel (directly bundled with Windows environment, version number 2.0 in Mac) was released.

Lotus 1-2-3 cannot be applied to Windows system for a long time. By 1988, the sales volume of Excel surpassed that of Lotus, which made Microsoft stand in the leading position of PC software manufacturers.

This incident led to the replacement of the overlord of the software kingdom. Microsoft consolidated its strong competitor position and found the direction of developing graphics software. After that, every two years or so, Microsoft will launch a new version to expand its advantages. The latest version of Excel is 16, also known as Microsoft Office Excel 2016.

In the early days, Excel became the target of trademark law because it had the same name as the software sold by another company. After trial, Microsoft was asked to name the software after Microsoft Excel in its official documents and legal documents. However, over time, this practice has gradually disappeared.

Although Excel provides a lot of user interface functions, it still retains the functions of the first spreadsheet software VisiCalc: rows and columns form cells, and data, formulas related to data or absolute references to other cells are stored in cells.

Excel is the first spreadsheet software that allows users to customize the interface, including fonts, text attributes and cell formats. The function of "intelligent recalculation" is also introduced. When the cell data changes, only the relevant data will be updated, while the original tabulation software can only recalculate all the data or wait for the next instruction. At the same time, Excel also has powerful graphic functions.

When Excel was first bundled into Microsoft Office in 1993, Microsoft redesigned the interface between Microsoft Word and PowerPoint to adapt to this extremely popular application program at that time.

Excel has supported Visual Basic for Applications (VBA) since 1993. VBA is a powerful tool, which makes Excel form an independent programming environment. With VBA and macros, you can automate manual steps. VBA also allows you to create forms to obtain information entered by users. However, the automation function of VBA also makes Excel the target of macro virus.

From 5.0 to 9.0, different Easter eggs are hidden in Excel.