Hi All,
I am trying to derive a formula for excel.

Below works.

Dim Test As String
'Test = "Car; color=blue;"

But now I want to add more fields and I do not want them to be fixed. e.g. (Test = "Car; color=blue;Model =Toyota;Year=2002;")

so I change to

Dim Test As String
Dim X As String
Dim Y As String

X = Toyota
Y = 2002

Test = "Car; color=blue;Model ="X";Year="Y";"

But I faced synatx error. What could be the issue?

Any help is appreciated!

Regards,
Nironto