Hi,
I have an Excel file that has been used as a company form for ages. It is not an actual 'Form' in the sense that when you open the file a 'User Form' pops up. It is basically a worksheet that has been set up to look like a Form when filled in and printed. With that said, I don't think they want me doing to much to this form. I was only asked to insert drop-down calendars in some of the cells where they have dates to be entered.
I found the following website that walked me through doing this:
http://danielcurran.com/instructions/insert-a-drop-down-calendar-menu-in-excel-choose-a-date/
However, I've also added a button on the form that launches a 'Clean-up' macro to wipe out any leftover data on this so called form that the previous user may have saved into the form template file. I have code that deselects any selected checkboxes and also cleans out any data typed into the form's fields. I just can't seem to come up with the code to clear out the date in the Microsoft Date Picker calendar. I do have the checkbox setting set to 'True' and even wondered if that could be deselected and give it a null date. Any help would be much appreciated.
Thanks,
Steve
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar