当我尝试使用在另一个子例程中的子例程中创建的变量时遇到问题。在下面的示例中,我在Sub part0中创建变量Power_Origine,Power_Destination ...,可以在Sub part1中使用其中之一,但是在一个子例程(part2)中不能使用多个变量。
Sub part0()
Power_Origine = 1
Description_Origine = 2
KnownUser_Origine = 3
Power_Destination = 1
Description_Destination = 2
KnownUser_Destination = 3
part1 (Power_Destination)
part2 (Power_Origine, Power_Destination, Description_Destination, KnownUser_Destination)
'part2 Power_Origine, Power_Destination, Description_Destination, KnownUser_Destination ' This does not work either
End Sub
Sub part1(Power_Destination As Integer)
MsgBox Power_Destination
End Sub
Sub part2(Power_Origine As Integer, Power_Destination As Integer, Description_Destination As Integer, KnownUser_Destination As Integer)
MsgBox "Hello " & Power_Destination & Description_Destination
End Sub
如何在子例程part2中调用这4个变量(Power_Origine,Power_Destination,Description_Destination,KnownUser_Destination)?
谢谢。
但是我不能在一个子例程中使用多个变量(第2部分)
您可以。只需删除(
和)
。所以变成
part2 Power_Origine, Power_Destination, Description_Destination, KnownUser_Destination
或使用
Call part2(Power_Origine, Power_Destination, Description_Destination, KnownUser_Destination)
与上面相同。您仍然可以得到一个错误,因为你已经声明Power_Origine As Integer, Power_Destination As Integer, Description_Destination As Integer, KnownUser_Destination As Integer
中part02
,但part0
他们Variants
。声明为Integer
中part0
,它会工作:)
Sub part0()
Dim Power_Origine As Integer
Dim Description_Origine As Integer
Dim KnownUser_Origine As Integer
Dim Power_Destination As Integer
Dim Description_Destination As Integer
Dim KnownUser_Destination As Integer
Power_Origine = 1
Description_Origine = 2
KnownUser_Origine = 3
Power_Destination = 1
Description_Destination = 2
KnownUser_Destination = 3
part1 Power_Destination
part2 Power_Origine, Power_Destination, Description_Destination, KnownUser_Destination
End Sub
Sub part1(Power_Destination As Integer)
MsgBox Power_Destination
End Sub
Sub part2(P_Orig As Integer, P_Dest As Integer, D_Dest As Integer, K_Dest As Integer)
MsgBox "Hello " & P_Dest & D_Dest
End Sub
您可能还想阅读按引用和按值传递变量
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句