CONCATENATE

[MJA]

Hello all,

I want (in VB) to use the formula CONCATENATE.
I want a combobox.text and a word (“hello”) to merge.

ActiveCell.FormulaR1C1 = "=CONCATENATE(combobox1.text, “hello”)"

The code above doesn’t do the trick!
Who can help me?

 

[WillR]

try

value = worksheetfunction.concatenate(value1,value2)

hth