UserForm Code Question/Help

I don't quite understand, i.e., you say the userform has ONE textbox, and ONE Enter button; but, then you say you want data from textbox1 or textbox2...entered on the sheet.

However, you could declare a global variable, say, BtnNum. Then, in the five button click events that call the userform, you could set BtnNum to the number of that particular button before calling the userform.

The code for the Enter button click event would use a SELECT CASE BtnNum routine to check the value of BtnNum and select the appropriate activecell into which the data would be copied.