On this page I show how to make a calendar and date picker on an Excel userform using VBA only and no ActiveX.

In the U.S.A (English), where the first day of the week is Sunday and not Monday, the "day labels" from left to right will be SU, MO, TU, WE, TH, FR and SA, and February 1st 2016 will be in the second column, below MO.

In other words it is sensitive to the system's language and first day of the week settings. The possible date formats are also based on the system settings.

By using VBA only and no ActiveX you avoid compatibility problems, because different MS Office versions use different ActiveX controls for calendars.

You can use the calendar to select (up to) two dates for whatever purpose you want. The selected dates are put in two labels, and if you click one of these labels, you can copy the date to a cell or a range of cells.

I show and explain some of the macros below, but I cannot show them all. If you want to see the rest, you can download a zip compressed workbook with the example.

The calendar is on a userform (see image above) with a frame, labels, combo boxes and command buttons.

For event handling (when the user selects a date) the calendar uses a simple class module instead of writing a click procedure for each and every date label.

Of course it also uses quite a few date functions like getting the first day of the week, first day of the month, weekday names in the user's language, checking for leap year etc.

I am a lousy designer, so change the userform's look as you like; but unless you change the code, the labels for date picking must all be in Frame1.

The Collections

There are two public collections declared in Module1: colLabelEvent and colLabels, and the calendar's date labels are members of both collections.

colLabelEvent is a collection of the event handler classes for the labels, and colLabels enables us to change the properties of each label like e.g.: colLabels.Item(variable for label name).Visible = False

The userform's Initialize procedure

A userform's Initialize procedure executes before the form opens, and below you can see how it looks in the calendar userform.

Tamil Sex Dance Videos 3gp Patched _top_ <Top-Rated>

The Evolution of Tamil Dance: A Reflection of Patched Relationships and Romantic Storylines

Tamil dance, a traditional form of expression in South India, has been a cornerstone of cultural heritage for centuries. With its rich history and diverse forms, Tamil dance has not only entertained but also conveyed complex emotions, relationships, and storylines. In recent years, the dance form has incorporated modern themes, including patched relationships and romantic storylines, making it more relatable and appealing to contemporary audiences.

Traditional Roots

Tamil dance, also known as Bharatanatyam, has its roots in ancient temples and royal courts. The dance form was initially performed as a devotional offering to deities, with intricate hand gestures, footwork, and facial expressions. The traditional repertoire included stories from Hindu mythology, with a focus on spiritual and philosophical themes.

Modern Twists

In recent years, Tamil dance has undergone a significant transformation, incorporating modern themes and storylines. Choreographers have begun to experiment with new ideas, exploring complex relationships, romance, and social issues. This shift has not only attracted a younger audience but also provided a platform for dancers to express themselves more freely.

Patched Relationships

One of the popular themes in modern Tamil dance is patched relationships. These storylines often revolve around couples who have separated due to various reasons, only to reunite later. The dance performances depict the emotional turmoil and longing that come with rekindling a lost love. Through powerful expressions and movements, dancers convey the pain, regret, and ultimately, the joy of reuniting with a loved one. tamil sex dance videos 3gp patched

Romantic Storylines

Romantic storylines have also become a staple in modern Tamil dance. These performances often feature couples in love, navigating the ups and downs of relationships. The dance routines are designed to evoke feelings of passion, love, and heartbreak, leaving the audience emotionally invested in the story. Choreographers use a range of techniques, including suggestive movements, eye contact, and body language, to convey the intensity of romantic emotions.

Influence of Cinema

The influence of Tamil cinema, also known as Kollywood, can be seen in the way dance performances are choreographed and presented. Many popular film songs and sequences have been adapted into dance performances, making them more relatable and entertaining for audiences. The cinematic approach has also led to the incorporation of elaborate sets, costumes, and special effects, enhancing the overall visual appeal of the performances.

Impact on Audiences

The evolution of Tamil dance has had a significant impact on audiences. The incorporation of modern themes and storylines has made the dance form more accessible and appealing to a wider audience. The emotional resonance of patched relationships and romantic storylines has created a deeper connection between the performers and the audience. As a result, Tamil dance has become a popular form of entertainment, with many enthusiasts attending performances and learning the dance form.

Conclusion

Tamil dance has come a long way from its traditional roots, embracing modern themes and storylines. The incorporation of patched relationships and romantic storylines has not only made the dance form more relatable but also provided a platform for dancers to express themselves more freely. As Tamil dance continues to evolve, it is likely to remain a significant part of cultural heritage, entertaining and inspiring audiences for generations to come.

Notable Choreographers and Performers

Some notable choreographers and performers who have contributed to the evolution of Tamil dance include:

Lavanya: A renowned choreographer and dancer, known for her innovative and emotive performances.
Priya Paul: A popular dancer and choreographer, recognized for her captivating stage presence and expressive movements.
Shanmukh Priya: A talented dancer and choreographer, celebrated for her energetic and emotive performances.

Recommended Performances

Some recommended performances that showcase patched relationships and romantic storylines in Tamil dance include:

"Reunited": A dance performance that explores the emotions of rekindling a lost love.
"Love in Motion": A romantic dance performance that depicts the ups and downs of relationships.
"Heartbeat": A contemporary dance performance that explores the complexities of love and relationships.

In Tamil culture, dance is not merely a performance but a vital language used to resolve emotional conflicts and weave intricate romantic narratives. From ancient Sangam literature to modern Kollywood, dance serves as a bridge that "patches" strained relationships and brings romantic subplots to fruition. The Historical Foundation of Dance and Romance

The roots of this connection lie in ancient Tamil traditions where dance and drama were inseparable: Dramatic reasons for dancing in Indian movies : r/TrueFilm The Evolution of Tamil Dance: A Reflection of

You can use this for a blog, a video essay script, or social media storytelling.

1. "Kannalane" – Bombay (1995)

A.R. Rahman’s melody. Two lovers separated by communal riots. When they meet again, there is no apology. Instead, a rain-soaked, folk-infused dance where he cups her face, she turns away, he pulls her back. The thavil beats mirror his pounding heart; her hesitant kummi steps mirror her fear. By the final chorus, their movements sync. Dance as ceasefire.

Beyond the Steps: How Tamil Cinema Uses Dance to Patch Relationships and Weave Romantic Storylines

In the grand tapestry of Tamil cinema, dance is rarely just an interval of entertainment. It is a plot device, a weapon of persuasion, and most importantly, a sutradhar (narrator) for the heart. When a relationship is fractured—by ego, circumstance, or family opposition—the film’s hero and heroine rarely sit down for a therapy session. Instead, they enter a song sequence.

The concept of "Tamil dance patched relationships and romantic storylines" is not merely about choreography; it is a deep-seated cultural trope where movement replaces dialogue, rhythm mends trust, and a single duet can turn enemies into lovers. From the rain-soaked villages of the 1980s to the neon-lit clubs of contemporary Chennai, dance remains the ultimate glue for fractured romance.

Let us dissect how Tamil filmmakers have mastered the art of repairing love through the language of dance.

2. The Mirror of Emotions: Salangai Oli and Sachein

Sometimes, the couple is separated not by ego, but by duty or circumstance. Here, dance acts as a mirror.

In the classic Salangai Oli, dance is the very fabric of the characters' lives. When the characters communicate through art, they are communicating their deepest traumas and loves. It’s a sophisticated form of storytelling where a Bharatanatyam recital isn't just a performance; it is a plea for understanding. Lavanya : A renowned choreographer and dancer, known

Contrast this with the commercial charm of Sachein. In the song Vaadi Vaadi, the protagonist uses dance as a way to grab the attention of the aloof heroine. He is constant, he is present, and he is joyful. Over the course of the song, her icy demeanor melts. The dance here acts as a slow-release mechanism—gradually patching the distance between the "cool guy" and the "serious girl" until they are equals.

The Three Pillars: Dance as Healer, Confessor, and Weapon

In patched relationship storylines, dance is never just performance. It serves three critical functions:

The Initialize procedure ended by calling the LabelCaptions procedure passing two arguments, namely the present month and year.

The LabelCaptions procedure does several things that determine the look of the calendar, and it is called every time the user changes month or year.

It checks stuff like the number of days in the month, where to put the first date according to the first day of the week, it finds the first day of the month and more. Here is how it looks:

Sub LabelCaptions(lMonth As Long, lYear As Long)
Dim lCount As Long            'Counter
Dim lNumber As Long           'Counter
Dim lMonthPrev As Long        'Previous month
Dim lDaysPrev As Long         'Days in previous month
Dim lYearPrev As Long         'Previous year

'Get the month name from the month number
sMonth = MonthName(lMonth)

'Save month number in variable
lSelMonth = lMonth

'Save year in variable
lSelYear = lYear

'Prepare for getting days in previous month
Select Case lMonth
   Case 2 To 11
      lMonthPrev = lMonth - 1
      lYearPrev = lYear
   Case 1
      lMonthPrev = 12
      lYearPrev = lYear - 1
   Case 12
      lMonthPrev = 11
      lYearPrev = lYear
End Select

'Days in month (function call - see below)
lDays = DaysInMonth(lMonth, lYear)
'Days in previous month
lDaysPrev = DaysInMonth(lMonthPrev, lYearPrev)

'If it is Jan. 1900 the
'back button is disabled.
If lSelYear >= 1900 And lSelMonth > 1 Then
   lblBack.Enabled = True
ElseIf lSelYear = 1900 And lSelMonth = 1 Then
   lblBack.Enabled = False
End If

'If this wasn't started by a selection
'in one of the combo boxes (month, year).
If bCmbSel = False Then
   cmbMonth.Text = sMonth
   cmbYear.Text = lYear
End If

'Find the first date in the month.
lFirstDayInMonth = DateSerial(lSelYear, lSelMonth, 1)

'Find the weekday number using local settings for
'first day of the week. We want to know if it is a
'Monday etc. for putting the first day of the month
'in the right weekday position.
'The first day of a week varies from country to country.
'In USA it is Sunday, in Denmark it is Monday.
'So we use vbUseSystemDayOfWeek to get the local settings.
lFirstDayInMonth = Weekday(lFirstDayInMonth, vbUseSystemDayOfWeek)

If lFirstDayInMonth = 1 Then
   lStartPos = 8
Else
   lStartPos = lFirstDayInMonth
End If

'Days from previous month if the
'first day in the month is not a monday.
lNumber = lDaysPrev + 1
For lCount = lStartPos - 1 To 1 Step -1
   lNumber = lNumber - 1
   With colLabels.Item(lCount)
      .Caption = lNumber
      .ForeColor = &HE0E0E0
   End With
Next

'The labels/buttons for the days of the month.
lNumber = 0
For lCount = lStartPos To lDays + lStartPos - 1
   lNumber = lNumber + 1
   With colLabels.Item(lCount)
      .Caption = lNumber
      .ForeColor = &H80000012
   End With
Next

'The days (labels) in next month
lNumber = 0
For lCount = lDays + lStartPos To 42
   lNumber = lNumber + 1
   With colLabels.Item(lCount)
      .Caption = lNumber
      .ForeColor = &HE0E0E0
   End With
Next

End Sub

Below is the function that finds the number of days in the selected month. It is quite simple.

Function DaysInMonth(lMonth As Long, lYear As Long) As Long

'Number of days in month
Select Case lMonth
   Case 1, 3, 5, 7, 8, 10, 12
      DaysInMonth = 31
   Case 2
      'Leap year?
      If IsDate("29/2/" & lYear) = False Then
         DaysInMonth = 28
      Else
         DaysInMonth = 29
      End If
   Case Else
      DaysInMonth = 30
End Select

End Function

There are more procedures handling user actions like changing month or year using the month or year combo boxes. That is more or less trivial stuff, and you can see the code, if you download the workbook.

The event handling class

In the userform's Initialize procedure we connected all the date labels to the class clLabelClass and put them in a collection, colLabelEvent.

The user picks a date by clicking a date label, and if you didn't have the class handling this event, you would have to write a click procedure for each end every label. Now all clicks are handled by the class module code below.

Option Explicit

'By declaring Public WithEvents we can handle
'events "collectively". In this case it is
'the click event on a date label, and by
'doing it this way we avoid writing click
'events for each and every date label.
Public WithEvents InputLabel As MSForms.Label
Private Sub InputLabel_click()

'We change the look of the selected day
With InputLabel
   'If previous month
   If .Tag < lStartPos Then
      If UserForm1.lblBack.Enabled = True Then
         UserForm1.lblBack_Click
      End If
      Exit Sub
   End If
   If .Tag > lDays + lStartPos - 1 Then
      UserForm1.lblForward_Click
      Exit Sub
   End If
   'If selected already, we exit
   If .BorderColor = vbBlue Then Exit Sub
   
   .BorderColor = vbBlue
   .BorderStyle = fmBorderStyleSingle

   'If another day was chosen before this
   'one, we make that label look normal.
   If Len(sActiveDay) > 0 Then
      If sActiveDay <> InputLabel.Name Then
         With colLabels.Item(sActiveDay)
            .BorderColor = &H8000000E
            .BorderStyle = fmBorderStyleNone
         End With
      End If
   End If
   sActiveDay = InputLabel.Name
   lFirstDay = Val(InputLabel.Caption)
   
   'If a second date has not been selected
   If bSecondDate = False Then
      UserForm1.FillFirstDay
   Else
      'If it is the second date selected
      UserForm1.FillSecondDay
   End If
End With

End Sub

That was the most important parts of the calendar's code. To see the rest, download the workbook.

The selected date or dates will be in two labels on the user form, but internally they are stored in the variables datFirstDay and datLastDay (declared on module level in the userform).

A date or dates can be used in many ways, and you can put your own code in the OK button's click procedure.

As sample code I find the difference in days between the two dates and display it in a message box, before the form closes. You can just replace that with your own code.

By picking my birthday and the day I write this, I can see, that I have lived for 21979 days. Time sure flies ...