Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. 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