excel宏（VB）常用保留字及关键字整理

最新推荐文章于 2025-08-20 10:08:29 发布

原创最新推荐文章于 2025-08-20 10:08:29 发布 · 4.2k 阅读

3 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

本文整理了Excel宏（VB）中的常用保留字和关键字，特别提到在循环控制中，Do While结构因其便捷的break功能，更适合Excel编程。此外，VB的逻辑值包括True、False和Null，且eqv关键字用于判断逻辑值相等。注意，VB的注释符号为'。整理过程虽繁琐，但有助于理解Excel宏编程。

接上一篇创建excel宏的hello world程序，说好的关键字整理w

首先是一些常用的保留字。

C++/Java中的关键词	VB中对应的实现方法	示例
if	If (boolean expresssion) Then action statements Else action statements End If	If (a > b) Then MsgBox ("a is bigger") Else MsgBox ("b is equal or bigger") End If
switch (form1)	Select Case variable Case value1 action statements Case value2 action statements Case Else action statements End Select	Select Case x Case 1 MsgBox ("It's 1.") Case 2 MsgBox ("It's 2.") Case Else MsgBox ("It's not 1 or 2.") End Select
switch (form2)	Select Case variable Case Is boolean expression action statements Case Is boolean expression action statements Case Else action statements End Select	Select Case x Case Is < 5 MsgBox ("smaller than 5") Case Is > 10 MsgBox ("bigger than 10") Case Else MsgBox ("none") End Select
? :	IIf(boolean expression, value1, value2)	IIf(a > b, a, b)
for	For i = value1 To value2 action statements Next	For i = 1 To 5 MsgBox (i) Next
while (form1)	While (boolean expression) action statements Wend	i = 0 While (i < 5) i = i + 1 MsgBox (i) Wend
while (form2)	Do While (boolean expression) action statements Loop	i = 0 Do While (i > 5) i = i + 1 MsgBox (i) Loop
do while	Do action statements Loop While (boolean expression)	i = 0 Do i = i + 1 MsgBox (i) Loop While (i > 5)
break (for)	Exit For	For i = 1 To 5 MsgBox (i) If (i > 3) Then Exit For End If Next
break (while/do while)	Exit Do	i = 0 Do While (True) MsgBox (i) i = i + 1 If (i > 3) Then Exit Do End If Loop