hello
I want to type numbers into a userform which will then write the numbers to the spreadsheet
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!
hello
I want to type numbers into a userform which will then write the numbers to the 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.
Don’t have an account yet? Register yourself now and be a part of our community!