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

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

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

End with


"Pawan" wrote:

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

Perfect...!

Thank a ton.. :)

"Joel" wrote:

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

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

End with


"Pawan" wrote:

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