VBA 计ç®è¢«7æ´é¤çæ°å个æ°çç¨åºï¼
Sub aaa()
Dim n As Integer, i As Integer, he As Integer
n = Application.InputBox("请è¾å
¥èªç¶æ°", "æ大å¼", 0, , , , , 1)
For i = 0 To n
If i Mod 21 = 0 Then
he = he + i
End If
Next
MsgBox he ^ (1 / 2)
End Sub
Visual Basic for Applicationsï¼VBAï¼æ¯Visual Basicçä¸ç§å®è¯è¨ï¼æ¯å¾®è½¯å¼ååºæ¥å¨å
¶æ¡é¢åºç¨ç¨åºä¸æ§è¡éç¨çèªå¨å(OLE)ä»»å¡çç¼ç¨è¯è¨ã主è¦è½ç¨æ¥æ©å±Windowsçåºç¨ç¨å¼åè½ï¼ç¹å«æ¯Microsoft Office软件ãä¹å¯è¯´æ¯ä¸ç§åºç¨ç¨å¼è§è§åçBasic èæ¬ã该è¯è¨äº1993å¹´ç±å¾®è½¯å
¬å¸å¼åççåºç¨ç¨åºå
±äº«ä¸ç§éç¨çèªå¨åè¯è¨--------Visual Basic For Application(VBA)ï¼å®é
ä¸VBAæ¯å¯çäºVBåºç¨ç¨åºççæ¬ã微软å¨1994å¹´åè¡çExcel5.0çæ¬ä¸ï¼å³å
·å¤äºVBAçå®åè½ã
温馨提示:答案为网友推荐,仅供参考