How to insert a formula in a worksheet thorugh userform

[MovieFan]

Hi All,

I want to insert a formula in a cell in a worksheet. The formula has
two parts. The first part is a function and the second is a also a
function but it has parameters that are taken from different variables
from the userform. For eg. I use the time() function. The parameters
for time() function are stored in variables part1,part2 and part3. I
then use a string variable to store the whole formula like
frmstr = time(int(part1),int(part2),int(part3)
then I use range("A3").select
activecell.Offset(0,1).formula = "=now()" + frmstr and get a "Type
Mismatch" Error.

Can anyone tell me how to substitute the formula (which is now() +
time(x,x,x) into the required cell.

Thanks in advance.

regards

 

[MovieFan]

Hi All,

I want to insert a formula in a cell in a worksheet. The formula has
two parts. The first part is a function and the second is a also a
function but it has parameters that are taken from different variables
from the userform. For eg. I use the time() function. The parameters
for time() function are stored in variables part1,part2 and part3. I
then use a string variable to store the whole formula like
frmstr = time(int(part1),int(part2),int(part3)
then I use range("A3").select
activecell.Offset(0,1).formula = "=now()" + frmstr and get a "Type
Mismatch" Error.

Can anyone tell me how to substitute the formula (which is now() +
time(x,x,x) into the required cell.

Thanks in advance.

regards

Hi All,

I resolved it myself using the "&" ampersand instead of the addition
sign "+".!!!!!