How do I get input from a text box and save it to a worksheet?

Posted by Kurt on October 31, 2000 7:16 AM

Hello everyone,

How do I get data from a text box? First, I want to check for three values either one, two, or three and then I want to save the user's input to a worksheet.

Any help would be greatly appreciated.

Thanks,

Kurt

Posted by JAF on November 01, 2000 3:21 AM

Kurt

I have used the following in the past and it worked for my requirements. Hope this helps.

Range("destination").Value = TextBox1.Value

JAF