How do I create a User form to input Data into an Ecel spreadsheet

[Guest]

I would like to create a user form where the user enter
1) Task No.
2) Task Description
3) Task Starting Date
4) Duration (days)

The form should also have a "Clear content" Command button to clear data
entered into any fields and also a "Submit Button".

Once the data is entered and the "Submit Button" is clicked, the data must
then be automatically entered into an Excel work sheet. Ideally a pop up
calander should appear when the user click on the "Task Starting Date" field
to select a date.

 

[Nigel]

Start by reviewing the following.....

http://www.contextures.com/xlUserForm01.html

 

[Guest]

Thank you Nigel, the info provided solved my headache