Activecell.formula combine with textbox value

Dear all,

I would like your help in guiding me on how to add textbox value inside userform into the formula such as below.

ActiveCell.FormulaR1C1 = "=textbox1.value*4.24*1.15*RC[-21]"

However it not picking up the value.

Any suggestion.

Thanks in advance

any gentlemen and beautifull girl whose can help me?

any expert here?

Hi,

The keyword here is concatenation.

ActiveCell.FormulaR1C1 = "=" & TextBox1.Value & "*4.24*1.15*RC[-21]"


Hope that helps...

Colin,

you are the man...
expert man.

its working.

thanks.