Hi there,

I have built a Data Capture Form on Excel 2003 VBA forms. I have a calendar on the form but just need a couple of things to make it work.

1. When a user opens the form, how can I get the calendar to automatically go to today's date?

2. When the user clicks OK I need the date on the calendar to go into the first column on the excel spreadsheet.

Can you help??