Userform

[Malcolm torishi]

Is it possible to have a user form that pops up by a click of a button and within that user form are text fields that the user fills in. And by pressing a button on the userform the text boxes that are filled in copy into say column F on sheet 2 along side the last entry in column E. So if the user types in a name in column E4 then by pressing the button on the userform text box will drop into F4 and so on
thank you

 

[sergioMabres]

Here is an idea you could use the Data Form Option, if you do not see the Data Form Option activate it, here is how
https://trumpexcel.com/data-entry-form/
Cheers
Sergio