CONCATENATE 2

[MJA]

Cells(1, 1).Formula = "=CONCATENATE(" & ComboBox6.Value & ",""Martin"")"

The formula almost works perfectly BUT when I look in cells(1, 1) the combobox value stands without the "" . For example the combobox value is Hello, the formula in cells (1, 1) must be =CONCATENATE("Hello";"Martin") instead of =CONCATENATE(Hello;"Martin") without the " before and after Hello.
What must I do in VB to get the " before and after Hello in cells(1, 1)???

 

[Andrew Poulsom]

You need some more quotes:

Cells(1, 1).Formula = "=CONCATENATE(""" & ComboBox6.Value & ""","" Martin"")"

I also inserted a space before Martin.

 

[MJA]

Sorry dude, you're solution doesn't work!

 

[Andrew Poulsom]

It works for me. What result are you getting?

Make sure you copy it exactly (use copy and paste):

Cells(1, 1).Formula = "=CONCATENATE(""" & ComboBox6.Value & ""","" Martin"")"