Update: I gave up on trying to figure out the Microsoft Calendar and how to control it with a macro. However, I did find a much freindlier solultion here for anyone else that this may help...
http://www.ozgrid.com/forum/showthread.php?t=142603&page=2
(see post# 18)
Regards,
Steve
--- In ExcelVBA@yahoogroups.com, "sspatriots" <sspatriots@...> wrote:
>
> 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