Write Numbers from userform to Spreadsheet

I am using that you shall be typing data into textboxes.

Use the following code to extract the data from textbox on form to worksheet

Worksheets("Sheet1").cells(1,1).value = userform1.textbox1.value

Hope this helps.

Ram P

Another way, depending on your needs, is to set the ControlSource property to the needed cell. You can do this at Design time via the Properties Window on the Control.