因此,我构建的字符串,我希望它是逐行组织的每一个条目。所以简单地说,在VBA中EndL的等价性是什么?
,这是我的代码:
If chkMonA = True Then
additionString = additionString + "Monday"
End If
If chkTuesA = True Then
additionString = additionString + "Tuesday"
End If
If chkWedA = True Then
additionString = additionString + "Wednesday"
End If
If chkThursA = True Then
additionString = additionString + "Thursday"
End If
If chkFriA = True Then
additionString = additionString + "Friday"
End If对于那些不知道任何C++的人,我会举一个例子来说明我想做什么。假设chkTuesA、chkThursA和chkFriA都是真的。我希望additionStrings输出如下所示:
Tuesday
Thursday
Friday发布于 2015-01-30 15:48:05
vbLf (Lf =线路馈电)
additionString = additionString + "Monday" + vbLf发布于 2015-01-30 15:50:22
假设输出是一个字符串,由换行符分隔,而不是数组,我只需要写一个这样的函数:
Function AddToString(byval sAdditionString as string, sDay as string) as String
Dim sReturn as String
sAdditionString = iif(sAdditionString="", _
sReturn = sDay, sReturn = sAdditionString & vbNewLine & sDay)
AddToString = sReturn
end function像这样打电话:
additionString = AddToString(additionString,"Monday")发布于 2015-01-30 15:54:03
使用VBNewLine或VBLf返回新行。
https://stackoverflow.com/questions/28239464
复制相似问题