VBA Express : Excel - Pick Calendar control form

Excel

Pick Calendar control form

Ease of Use

Intermediate

Version tested with

2003 to 2010

Submitted by:

psawyer

Description:

I had trouble with the MS calendar control to work in Windows 7. I finally programmed the following control which works great. It event contains holidays and calendar weeks.

Discussion:

Can be used in any table containing a column with date. A double click event or a button can be used to call the form.

Code:

instructions for use

See sample file. 1. Import/copy module "SF_DatePick" To project 2. add code To your sheet. Example: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column = 3 Then ' Column with dates Call SF_DatePick.DatePickinRange(target) Cancel = True End If End Sub

How to use:

See sample file.

Test the code:

See sample file.

Sample File:

PickDateForm.zip 53.5KB

Approved by Jacob Hilderbrand

This entry has been viewed 465 times.