View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohannM JohannM is offline
external usenet poster
 
Posts: 13
Default 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.