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

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.

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

Start by reviewing the following.....

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


--
Cheers
Nigel



"JohannM" wrote in message
...
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.