excel - VBA中的换行符以及它是否是一个volatile函数

Question

1. 如何在这组代码中添加换行符 ( Alt+ )？Enter我的最终结果应该是这样的：

   Text 1
   Text 2
   Text 3
   

   不是

   Text 1 Text 2 Text 3
   

2. 接下来，只是一个简单的问题，这组 UDF 代码是否被视为volatile 函数？

   Function MYVLOOKUP(pValue As String, pWorkRng As Range, pIndex As Long)
       Dim rng As Range
       Dim xResult As String
       xResult = ""
       For Each rng In pWorkRng
           If rng = pValue Then
               xResult = xResult & " " & rng.Offset(0, pIndex - 1)
           End If
       Next
       MYVLOOKUP = xResult
   End Function
   

标签： excelvba