posting textbox data from a form into a worksheet

**cH3wY** · 01-31-2007, 05:45 AM

hi
first post

i have a form that i created in visual basic that opens with the click on a command button on my worksheet. The form has some texts boxes on it. I then have another command button to close the form. When i close the form i want the data entered in the text boxes to be posted into a cell on the worksheet. any help on how to do this is appreiated as i am just starting out in VB and VBA.

thanks alot
cH3wY

**funkymonkUK** · 01-31-2007, 06:14 AM

if your userform is named example "Userform1" and the text box you you have is named "Textbox1" then type the following

sub transferdata

range("a1").value = userform1.textbox1.value ' transfer the value
userform1.textbox1.value = "" ' to clear the value

end sub

you could place this in your code for the commandbutton or in the code of the command button typ the name of the sub and it will call that sub.