我正在尝试做一些调试,我有一个集合,我创建了几个不同的字符串。我想要做的是返回并设置另一个变量,它等于集合中的第二项。这个是可能的吗?请参阅下面一个非常简化的示例:
Dim TagForms As New Collection
Dim TagForm1 As String
Dim TagForm2 As String
Dim TagForm3 As String
Dim Test As String
TagForm1 = "Cat"
TagForm2 = "Dog"
TagForm3 = "Pig"
Set TagForms = New Collection
TagForms.Add TagForm1
TagForms.Add TagForm2
TagForms.Add TagForm3
Test = TagForms(2) 'This doesn't work
Set Test = TagForms(2) 'This also doesn't work发布于 2019-11-01 19:12:36
由于变量' Test‘是一个字符串,最后一个代码行'Set Test= TagForms(2)’不能工作。正确的代码行是'Test = TagForms(2)‘。此代码返回“Dog”
https://stackoverflow.com/questions/58662178
复制相似问题