1. Open Microsoft Office Excel 2007 and click Start->; Excel options.

2. In the pop-up dialog box, select the General tab, on the right, click the Display Development Tools tab on the ribbon, and then click OK.

Enter radian in cell A 1, angle in cell B 1, 3. 14 in cell A2, and then enter the formula = degree (A2) in cell B2. After pressing Enter, the output result of this cell is 179. 56438.6866666666 1

Note: DEGREES function is used to convert radians into angles.

4. Next, we use VBA to realize the same function. Click the developer tab, and then click Visual Basic to start the Visual Basic editor.

5. Right-click Microsoft Excel Object and click Insert->; "Module", create "module 1" and enter the contents of this module:

Subtransformation ()

MsgBox application. Worksheet Functionality (3. 14)

End joint

Click Run Sub-process/User Form, select Convert in the pop-up dialog box, and then click Run.

6. The program pops up a dialog box, and the result is the same as the formula output in Excel, but the number of effective digits is different, which can be selected as needed.

Summary: In VBA programming, the WorkSheetFunction method can be used to reference Excel functions, which can facilitate the reference of functions, avoid spending more time on custom functions, and effectively improve work efficiency.