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.
|