VBA_DatePicker is a datepicker written in VBA. It was developed for developers to provide a way for users to select a date from a calendar.
- Open a project in Microsoft Visual Basic for Applications (VBA Editor).
- Import the following files: (
File
>Import File
)DatePickerDayLabel.cls
DatePickerMod.bas
FormDatePicker.frm
(Ensure thatFormDatePicker.frx
is within the same folder before importing)
Dim result as Variant
result = DatePickerMod.selectDate()
Note:
DatePickerMod.selectDate()
will returnNull
when the form is cancelled or closed.