The older versions have a control named as Calendar and for the new versions it is called the DT Picker control.

To remedy this, I suggest that you create your own calendar control, using a Userform.

Open your VBA editor, create a new UserForm and change its Name property to Calendrier.

If Left(Format(Date, dd), 1) 0 Then Me.Controls(Bouton Format(Date, d)).SetFocus Else Me.Controls(Bouton Format(Date, dd)).SetFocus.

The number of days vary from one month to another, so we will create them dynamically.

We will need to create to class module for the command buttons to work.

Private Sub BtnMouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single).

If EstJourFerie(maDate) Or Paques(Year(maDate)) maDate Then Btn.ControlTipText QuelFerie(maDate).

In the standard module created earlier, we will add three functions to identify holidays.

Public Function EstJourFerie(ByVal laDate As Date, Optional ByVal EstPentecoteFerie As Boolean True) As Boolean.

Our content is written in collaboration with IT experts, under the direction of Jean-Franois Pillou, founder of CCM.net.

Any copy, reuse, or modification of the content should be sufficiently credited to CCM ( ccm.net ).

Which Versions Of Excel For Mac Has Vba