Greetings!

I am trying to create a form in excel that will allow users to input data accurately and quickly. In column labeled "Date" (Column A) I would like to use the Calendar Control 11.0 control to allow users to pick dates quickly.

For a brief second, i got it to work correctly, and now I cannot get it to work at all.

All I did originally, was to go into VBA and insert a user form. I picked the Calender Control 11.0 and exited VBA. Then, when I went to my spreadsheet in any cell with a date in or above it or with the word "Date" above it, it would have a small icon to the right that I could click and a calendar would pop out and allow me to pick a date for that cell.

However, this went away after I saved it and now I cannot get it to work in any spreadsheet that I create. What am I missing. How does this control work?