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.

Windows 7 Ultimate Super Slim Edition X64 June 2019 New May 2026

The Windows 7 Ultimate Super Slim Edition x64 June 2019 New is a technical marvel of OS shrinking. It proves that Windows 7 can run comfortably on just 512MB of RAM. However, it is a time capsule.

Use it to play The Witcher 2, run an old CNC router, or keep a legacy scanner alive. Do not use it for banking, social media, or cloud storage. Respect the vintage, respect the risk, and enjoy the speed.

Did we miss your favorite "Lite" build? Let us know in the comments below. Stay retro, stay efficient.

Windows 7 Ultimate Super Slim Edition (x64), specifically the June 2019 version, is an unofficial, highly modified version of the operating system designed for low-end hardware. It aims to reduce the system's disk footprint and RAM usage significantly compared to a standard installation . Key Features and "Super Slim" Modifications

This edition typically includes several aggressive optimizations to achieve its "slim" status:

Reduced Footprint: The installed size is often reduced to approximately 3.8 GB to 5 GB , compared to the standard 16–20 GB required for a 64-bit install .

Performance Tweak: It is optimized for systems with as little as 1 GB of RAM and older processors like the Pentium 4 .

Pre-Integrated Software: Most versions from mid-2019 include Internet Explorer 11, .NET Framework 4.8, and various DirectX runtimes .

Updated Drivers: Common builds include generic Wi-Fi and manufacturer drivers to ensure functionality on hardware released between 2012 and 2016 . What is Removed?

To achieve its minimal size, the author (often credited to third-party groups like "Khatmau Sr" or "TeamDAZ") removes significant Windows components :

Multimedia & Accessories: Windows Media Center, WordPad, Help documentation, and several pre-installed games are typically removed .

Networking: Some "Super Slim" builds remove Remote Access and sharing features to save resources .

System Files: Native support for creating or opening ZIP folders may be removed to reduce the number of system dlls .

Visuals: While some maintain Aero Glass transparency, many unofficial wallpapers and custom themes are added to replace standard Microsoft assets . Security and Updates

June 2019 Baseline: This version typically includes security updates released through June 2019, including major certificate updates and SHA-2 support .

EOL Risks: Windows 7 reached its official End of Life in January 2020 . Using unofficial ISOs from repositories like the Internet Archive or Scribd carries security risks, as these images are modified by third parties and may include pre-installed activation tools like "Removewat" . AI responses may include mistakes. Learn more

Windows 7 Ultimate MULTI x64 (2019 Version) - Internet Archive

Windows 7 Ultimate Super Slim Edition x64 (June 2019) an unofficial, modified version of Windows 7 designed to reduce system resource usage and installation footprint

. Released near the end of official support for Windows 7, these builds typically integrate late-stage security updates while stripping away non-essential components. Key Features and Modifications Minimalist Footprint windows 7 ultimate super slim edition x64 june 2019 new

: Often requires as little as 3 GB of hard drive space and can run on 2 GB of RAM. Automated Setup

: Most versions skip the "Out-of-Box Experience" (OOBE), automatically creating a user account and bypassing license agreement screens for a faster install. Integrated Drivers & Software : Commonly includes built-in Wi-Fi drivers and Internet Explorer 11 June 2019 Updates

: These editions typically integrate official Microsoft security patches from June 2019, addressing several critical vulnerabilities. Stripped Components

: Non-essential features such as Remote Access, Sharing, and most default games are often removed to maintain the "super slim" profile. System Requirements (Estimated) Minimum Requirement 1 GHz or faster (x64) Hard Disk Space 3 GB to 20 GB (depending on build) DirectX 9 with WDDM 1.0 driver Important Security Considerations

Since these are unofficial "remastered" versions, users should be aware of the following: Source Reliability

: Downloading custom OS builds from untrusted sources carries risks of integrated spyware or keyloggers. End of Life

: Official support for Windows 7 ended in January 2020, meaning no further official security patches are provided by Microsoft beyond that period. Verification

: You can find various archived versions on platforms like the Internet Archive for research or legacy hardware use. Are you planning to install this on legacy hardware virtual machine Windows 7 Super Lite Edition - Overview & Demonstration

The Windows 7 Ultimate Super Slim Edition x64 (June 2019) is an unofficial, community-modified version of Windows 7 Ultimate designed to be extremely lightweight and minimalist. By removing non-essential system components, it achieves a significantly smaller installation footprint and lower resource usage compared to a standard installation. Core Features & Modifications

Reduced Size: The installation ISO is often compressed to roughly 3.3GB to 3.8GB, while the installed OS can occupy as little as 4GB to 5GB of disk space.

June 2019 Updates: This specific build typically includes major security rollups and updates released through June 2019, including Internet Explorer 11, updated .NET Framework (often 4.8), and manufacturer-specific Wi-Fi drivers.

Stripped Components: To achieve its "slim" status, several features are usually removed, such as: Multimedia: Windows Media Center and some games.

Utility: WordPad, help documentation, and some system fonts.

Advanced Networking: Remote Access and Sharing features are frequently disabled or removed.

Visual Tweaks: Many versions include custom themes, transparent windows (Aero Glass), and unofficial wallpapers. System Requirements

These editions are optimized for older hardware or netbooks where modern operating systems would struggle. Minimum Requirement Recommended (for x64) Processor 1 GHz or faster Dual-core or better RAM Storage 5 GB available space 16 GB+ for updates Graphics DirectX 9 with WDDM 1.0 WDDM 1.0 or higher Usage Considerations

Compatibility: Some drivers and native features (like ZIP file support) may be missing. You may need to manually install additional drivers after setup.

Activation: These unofficial builds are often pre-activated or include tools like RemoveWAT for activation. The Windows 7 Ultimate Super Slim Edition x64

Security Risk: As this is an unofficial third-party ISO, it may pose security risks. Official Microsoft support for Windows 7 ended in January 2020.

The "Windows 7 Ultimate Super Slim Edition x64 June 2019" is custom, unofficial modified version of the Microsoft Windows 7 operating system

. It was designed by independent modders to be a lightweight, resource-efficient alternative to the standard installation. Overview of "Super Slim" Edition

This edition is a "debloated" version of Windows 7 Ultimate, where non-essential components have been removed to reduce the disk footprint and RAM usage.

: Optimized for low-end hardware, older computers (specifically those from 2012–2016), or users who want a minimalist desktop experience. Development

: These "Super Slim" or "Super Lite" editions are typically produced by community groups like TeamDAZ and are not officially associated with or supported by Microsoft. Key Features (June 2019 Build)

Modified ISOs from mid-2019 often integrated updates that were released just before Windows 7 reached its official end-of-life. Integrated Updates

: Includes security updates and certificates up to 2019, along with .NET Framework 4.8 and Internet Explorer 11. Reduced Size

: While a standard Windows 7 x64 install usually requires 20GB of space, these slim versions can often be installed in as little as 3GB to 5GB. Driver Support

: Often includes pre-installed generic WiFi and LAN drivers to ensure immediate connectivity after installation.

: Many versions feature custom wallpapers, themes (like Aero Glass transparency), and modified installation screens. System Requirements Standard Windows 7 x64 Super Slim Edition (Est.) 1 GHz or faster 1 GHz (sometimes supports older P4) 2 GB minimum 1 GB to 2 GB 3 GB to 8 GB DirectX 9 with WDDM 1.0 Components Removed

To achieve its "Slim" status, the following are often stripped out: Networking

: Remote Access, Sharing features, and advanced networking tools. Multimedia

: Most default games (except basics like Solitaire), Windows Media Center, and various sample files. System Tools

: Redundant drivers, help files, and non-essential system services. Critical Considerations Security Risks

: Because these are unofficial builds, they may contain integrated "activators" (like DAZ Loader) or even hidden malware. There is no official way to verify the integrity of the ISO.

: Removing core components can cause compatibility issues with certain software or hardware drivers that depend on those stripped-out files. End of Support

: Microsoft officially ended extended support for all Windows 7 editions on January 14, 2020 Did we miss your favorite "Lite" build

. It no longer receives security updates, making it vulnerable to modern threats.

The content for Windows 7 Ultimate Super Slim Edition x64 (June 2019)

refers to an unofficial, modified version of Windows 7 designed for extreme efficiency on low-end hardware. This specific "June 2019" release typically integrates updates up to the end of Windows 7's primary support cycle, which officially ended in January 2020. Core Features and Modifications

These "Super Slim" or "Lite" versions achieve a small footprint by removing non-essential system components: Minimalist Size

: The installation footprint is significantly reduced, often requiring as little as 3 GB of hard drive space compared to the standard 20 GB for 64-bit Windows 7. Reduced Resource Usage

: Designed to run smoothly on legacy hardware, sometimes requiring only 2 GB of RAM for the 64-bit version. Removed Components : To save space, developers typically remove: Remote Access and Sharing features.

Large libraries of pre-installed games (keeping only basics like Solitaire).

Standard Windows fonts and drivers not required for basic functionality. Pre-Integrated Tools : Many versions include Internet Explorer 11 .NET Frameworks , and integrated Wi-Fi drivers to ensure functionality right after installation. System Requirements

While official Windows 7 x64 requires 2 GB of RAM and 20 GB of disk space, this "Super Slim" edition is optimized for: : 1 GHz or faster (x64).

: 2 GB (though some lite versions can boot with less, performance will be slow). : 3 GB to 10 GB of available disk space. Critical Considerations

You install this OS for one reason only: Old hardware revival. Here is what this edition demands vs. standard Windows 10:

You will find many "Super Slim" editions from 2016, 2017, or 2020. The June 2019 release is considered the "sweet spot" for two reasons:

Before downloading, understand the trade-offs. This is not for everyone.

Assuming you have verified the SHA-1 hash (1.4GB ISO), here is how to install it:

Tools needed:

Steps:

Date: April 12, 2026
Subject: Third-party modified OS image
Risk Assessment: High (Security & Stability)

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 ...