Does anyone know how to make a data entry worksheet in excel 2007?

Does anyone know how to make a data entry worksheet in excel 2007?

Hello everyone my name is andy...
is anyone know how to make a simple data entry worksheet in excel 2007?
i noticed that excel 2007 have a form control inside the developer tab
i can add input text box and command button in sheet1

but i dont know what syntax to insert inside that text box and command button
so if i click the command button anything i've inserted inside the text box will
be added to sheet2 as data records

please help

thank you

Hi Andy.

I have uploaded a sample file. Check if this is what you need.

dummydataentryFORM.xlsm