Originally Posted by
Richardall
Bluecactus, Thank you again for all the help. In one of your original replies, you mentioned that you couldn?t upload the file. Has that changed? Can you wrap this up and post it.
Here you go. This one contains mode 0 and mode 1 listed above.
You can look at the file, but to use it in VBA requires code like:
Load DatePick
Call DatePick.FillVars
DatePick.Show
Options are through...
DatePick.FillVars(defaultSelection, mode)
defaultSelection (optional, type Date) is the default date to be returned. If unspecified, Date (i.e., today's date) is used.
mode (optional, type Integer) is either 0 or 1 (default 0) in this revision.
mode 0: date returned immediately on clicking a day.
mode 1: date displayed on form when selected. Returned when user clicks 'OK' button. Allows user to select a date and hunt around the calendar some more before confirming the selection.
[7/7/05: File updated to fix a few minor cosmetic issues on Win VBA]
[7/7/05: File removed. Replaced with post #23]
Reply With Quote