Userform text box data into a sheet.

[Zimmerman]

Can someone help me out with getting the data entered into a userform text box entered into cells on a sheet. I have a userform that has a text box that's labeled "EmployeesTextBox" where the user will enter the number of employees needed. All I want to do is transfer what they entered into cell K51 on sheet labeled "1st Item"

Windows XP
Excel 2003

 

[Trevor G]

Behind a command button (named cmdAdd) place this in it, by double clicking the button

Sheets("1st Item").Range("K51")=me.EmployeesTextBox

 

[Zimmerman]

Sorry I guess it would be nice if i gave you all the info. How can i get this to be put in after the user hits the OK button.

 

[Trevor G]

The code I gave you will do this. In your VBA screen select the userform, then double click on your OK button and add the code.