Use Evaluate function to execuate function : Evaluate « Excel « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Excel
3. Evaluate

Use Evaluate function to execuate function

 

Public Sub ConcatenateExample1()
   Dim X As String, Y As String
   X = "Jack "
   Y = "Smith"
   MsgBox Evaluate("CONCATENATE(""" & X & """,""" & Y & """)")
End Sub

 

Related examples in the same category