clsCalendarDate and clsCalendarTime Classes

English | Русский | UserForms-Class-ALL

General Description

This project includes two classes for working with dates and times in Excel VBA:

• clsCalendarDate - date selection class
• clsCalendarTime - time selection class

Functional Capabilities

clsCalendarDate

The clsCalendarDate class provides functionality for adding a date selection calendar to a text field in an Excel VBA user form. It allows users to conveniently select dates, months, or years through a visual interface.

Main features:

• Date, month, or year selection
• Customization of date display formats
• Limitation of available date ranges
• Appearance customization (colors, icons)
• Support for various calendar modes

clsCalendarTime

The clsCalendarTime class provides functionality for adding time selection to a text field in an Excel VBA user form. It allows users to conveniently select hours and minutes through a visual interface using up/down arrows.

Main features:

• Time selection (hours and minutes)
• Customization of time display formats
• Appearance customization (colors, icons)
• Control of button visibility and position
• Support for various icons for the time selection button

Compatibility

Both classes are designed for use with Microsoft Excel VBA and require user forms.

Usage Examples

Detailed usage examples for each class are provided in the corresponding documentation files:

• clsCalendarDate usage example
• clsCalendarTime usage example