Value from userform to macro

[Pawan]

I have created one useform with a text box in it. I want the user to enter
the value in the box and that has to be used in my macro (which is in module)
for futher programming. I have renamed my textbox as 'uservl' and in the
macro i have written statement

With Cells(2, 19)
.Value = uservl.Value

End with

But tis not working. How can I do this?

Thank You

Pawan

 

[Joel]

You shuld reference a worksheet and need to also include the userrform

With Activesheet.Cells(2, 19)
.Value = userform1.uservl.Value

End with

 

[Pawan]

Perfect...!

Thank a ton..

You shuld reference a worksheet and need to also include the userrform

With Activesheet.Cells(2, 19)
.Value = userform1.uservl.Value

End with