With Excel, you can use Visual Basic to add a range of different features to your spreadsheets, including “UserForms.” Through UserForms, you can display an input form to the user that is separate from the main worksheet, which is useful for capturing data from individuals that may not be familiar with spreadsheets. With a little Visual Basic code, you can add all of this data to your spreadsheet in new rows. eRow=Sheet1.Cells(Rows.Count,1).End(xlUp).Offset(1,0).Row Then start a new line beneath this one and then enter the following: Cells(erow, 1) = TextBox1.Text If you renamed your text boxes, change “TextBox1” to the name you gave the first text box. Do this for each input box you created, starting a new line and entering the correct text box names as appropriate. Also, for each new line, increment the figure in the parentheses by one. For example, the next line might look like this: Cells(erow, 2) = TextBox2.Text Click the “Play” button at the top of the window to start capturing data. Writer Bio
